ISBN Consolidation
From MediaSell
ISBN Consolidation If you have inventoried several items with different SKUs that share the same ISBN and Condition, you may be in violation of Marketplace Listing Policies. Most marketplaces now enforce strict rules about "page-hogging." To read more about "page-hogging" and what some of the Marketplaces have to say about it, please click here. We have developed a tool to help sellers protect themselves.
- NEVER change the condition of an existing listing. You should close the listing and open a new listing instead. This goes doubly if you are using consolidation, because we will not send deletes out for the listings with the old condition.
Inventory- You need to contact us if you wish to have this feature enabled. In your email, please let us know for which Marketplaces you would like your items to be consolidated. We can activate this feature for the marketplaces of your choosing.
- Important!! - You MUST purge a marketplace if you have ISBN consolidation turned on for it. This is to delete your listings with your own SKUs from the marketplace, because after enabling consolidation FillZ will only export consolidated SKUs.
- ISBN consolidation is based on ISBN and Condition only.
- If you have items with the same ISBN and same Condition, but they have different prices, the listings will be consolidated and will appear on the markets with the highest price. If you would like us to use the lowest price, please let us know.
- The logic we're using to determine which note/description to send out when consolidation is turned on is based first on the highest quantity, and if the quantity is the same it's based on the most recent item added to FillZ.
- When you browse your inventory in FillZ, the items will appear the same. The consolidation occurs on export. Please see the "Orders" section below for clarification.
Example:
Before ISBN Consolidation
Listing 1: SKU: 000004 ISBN: 0060765860 Condition:New Price:20.00
Listing 2: SKU: 000005 ISBN: 0060765860 Condition:New Price:20.00
Listing 3: SKU: 000006 ISBN: 0060765860 Condition:Very Good Price:20.00
Listing 4: SKU: 02222007-FL ISBN: 0060765860 Condition:New Price:15.00
After ISBN Consolidation:
Listing 1: SKU: 000004 ISBN: 0060765860 Condition:New Price:20.00
Listing 3: SKU: 000006 ISBN: 0060765860 Condition:Very Good Price:20.00- Note that in the above example, there are still two separate listings because the items differ materially from each other; this is acceptable. Also notice that SKU 02222007-FL was rolled into SKU 000004 because these items have the same Condition and ISBN.
Orders- All items, regardless of quantity, will receive a new "Consolidated SKU" when we export to the marketplaces. The only area you will see the Consolidated SKU is in your orders page. These SKUs are generated using the ISBN of your items sandwiched between Z and ZN: "ZISBNZN". See example below. Even though we are generating a new SKU for you, we are still decrementing your inventory without issue.</u>
- This is the logic we're using to determine which SKU to match to:
- The item with the highest quantity number in FillZ will be matched first.
- If quantities are the same, the item the highest location number (lexically highest location (location Z1 picked before location A1).
- If the quantities and location data are the same, the item with the oldest Open Date is matched.
- You will notice that your location will appear differently. It will be a combination of your original sku, your location and the quantity of the consolidated item in the order. It will appear in the following format: YOUR SKU@YOUR LOCATION:Quantity of item in the Order. See the location field below for an example.
Example:
ISBN Consolidated Order
Order:#184689
Items New Location 1 Z1550224948ZN (Consolidated SKU) 1550224948(ISBN) New Book. No Marks. [1234567890123@Floor: 1] Paperback $10.00 (Your Sku) (Loc.) (Quantity)
