Set Quantity to 0 for Combinations that are not listed in the CSV Source File

Set Quantity to 0 for Combinations that are not listed in the CSV Source File

Avatar image
May 25, 2018
Davide wrote
Let's take this product example:
1A Main Reference

With Combination References for Sizes:
1A (M) (same as Main Reference)
1B (L)
1C (XL)
1D (2XL)
1E (3XL)

The CSV source file form the supplier at some point had all the above inventory
The supplier later removes References from source file when items become out of stock and discontinued
In this example, all References / SKUs have been removed except (1E 3XL)
At this point, I have orphan combinations with outdated Qty that will never get updated by the synchronizer
This is a big problem as we keep receiving orders for items that are not available

In the "Addon: Automated Product Import"
Then I suggest a new setting to "Handling of products that are not listed in source file:"
Currently the "Set product quantity to "0" when not listed in .csv" only affects main Reference

WE NEED A NEW OPTION to the same for Combinations "Set quantity to 0 for combinations that are not listed in the CSV" with option to email report of updated combinations.
New
4 votes
Vote
Reply
1 Answer
Avatar image
Aug 01, 2018
Davide wrote
During the Addon processing: "Automated Product Import"

Either allow to sync combinations without Main Reference in Supplier's source csv file.

Or, generate report of Main References without a match in order to manually check orphan combinations that are being lefout out without Quantity updated.