Do you have more than one supplier/product data feed source? If yes, this article is for you.
Why do we need to merge product data?
Imagine having 2 suppliers: Supplier A and Supplier B, each providing you with a data feed with multiple products:
Each feed has 4 products. Product B and Product C are present on both feeds.
The question is: what values should we use for Qty and Retail price? Merge settings are there to help.
The most common scenario for that situation will be:
- Quantity should be summed up and the result list will contain the SUM of all quantities of that product. In our case for Product B: Supplier A has 20 items available and Supplier A has 11 items, this will result in 31 total.
- The retail price can be MIN of suppliers' prices. For Product B: MIN($20,$22) = $20
Now let's see how to achieve that using Inventorize.io
Step 1. Go to Products > Merge
Step 2. Arrange Sources the way you need
You can Drag & Drop sources in the list. Sources are processed FROM THE TOP TO THE BOTTOM.
Step 3. Set the rules for the fields
Depending on the field type, different options are available:
- Overwrite - overwrites the value from the previous source
- Ignore - ignores (leaves the value from the previous source or empty if set for the first source)
- Sum - sums the value from the previous source with the value from the current source
- Max - sets the value of the current supplier if it's greater than the current value of the field
- Min - sets the value of the current supplier if it's less than the current value of the field
If you arrange sources the following way:
- Supplier A
- Supplier B
- Supplier C
And apply the overwrite rule for the same field for Supplier B & Supplier C, this will overwrite the value from Supplier A by that value of Supplier B and then it will overwrite that value by the value from Supplier C. So, the final result will be the value pulled from the feed of Supplier C