We are attempting to add order reconciliation functionality to a Drupal Commerce site: distributors can download orders placed for their products, they update in a CSV with status of those line items, then upload that CSV again to fill in the new information (fulfillment date, quantity fulfilled, etc) on the existing line items.

Unfortunately, Feeds doesn't seem to be able to update existing line items. I have the mapping set so the line item is my unique field, which means it should update when the line item ID matches (I've used Feeds a few times before and it always works well for that). If the settings allow for creating new items, it will make new ones with new line items rather than matching. If the settings are clear to only update existing items, it will say there is nothing new so doesn't do anything.

It is relying on a dev module Feeds Entity Processor, so it might be as simple as that module being buggy, or it might be something about how line items work which doesn't allow updating.

I appreciate any help that you can give, either along this approach or if you know of a completely different way.

  • 1
    I suggest to check your source with the Feeds Import Preview module. This can sometimes reveal where the issue lies. The Feeds Entity Processor does what it can to support most entity types, but since entity types are different from each other, some of them cannot be supported in a generic way.
    – MegaChriz
    Nov 6 '17 at 19:50

Turned out to be a silly mistake on my part caused by the way Excel determined width of my CSV file. The export function was exporting with the header Line item ID, but Excel's automatic sizing cut it exactly at Line item and so I ended up filling in the mapping wrong. Sometimes you need an extra pair of eyes to help you see a simple mistake like that.

The module works with line items.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.