Hello All-
For a sku, I physically have 2 in stock.
The Quantity Available = 0
The Open Qty = 2
If I update Quantity Available to 2, then I have a total of 4 (but I dont have 4, I have 2).
Where is the open qty coming from and how do I correct this? Or do I need to? Thanks, Joshua
Open quantity is how many you have listed on eBay. This quantity is reserved for eBay to prevent overselling. Don't overcompensate by adding 2 more. If you need to have some available quantity, then adjust your open quantity on eBay, but don't artificially inflate your inventory if you don't have that many in stock.
If you have the old Amazon integration, that will allocate inventory as well, causing quantity to be reserved in the 'open' column.
Ocean
Joshua, this is a very important distinction as I'm sure you are aware. When you submit your inventory upload file the column 'quantity update type' determines how you count your quantity. The open quantity means you have 2 allocated to a marketplace (for example an eBay ad with a quantity of 2).
When you do your upload, you probably want to use the UNSHIPPED quantity adjustment type. This will subtract out open, pending checkout, pending payment, and pending shipment quantities and set the remainder to available. So for your example:
You submit a quantity of 2, unshipped. We take 2 and subtract out the open listings (2) for a result of 0. This means you have 0 remaining to allocate to another site - which is true since you have them allocated to eBay.
Some links you may find useful:
This explains the different statuses and all the quantity upload types in detail: https://ssc.ChannelAdvisor.com/howto/inventory-upload-quantity-types
This explains how to 'juggle' allocated quantity between multiple marketplaces: https://ssc.ChannelAdvisor.com/howto/enable-shared-channel-inventory-quantity-sell-same-product-multiple-channels
Hope this helps
Chris
Thanks for the replies, but here is where I am getting lost. I use the UNSHIPPED value and I just finished the Amazon integration and have not started the eBay integration yet. That being said, should I download an inv file from Amazon and uplaod with the UNSHIPPED value into CA to correct this issue?
Thanks! Joshua
If you send unshipped quantity of 2, it'll correct the situation.
I'm lost here too. If you haven't done your eBay integration yet, you should never have any open quantity. updating from spreadsheet with inventory = 2 and inventory update type = unshipped will correct the issue from having 4 total back down to 2, but it doesn't deal with how you got a qty of 2 in the open column. When you click on that 2, what does the new page look like?
Ocean
I just sent a unshipped quantity of 2 and it still shows:
The Quantity Available = 0
The Open Qty = 2
Whats the next move?
Thanks!
Ocean is right - the quantity is correct, the solution to your issue is finding out why you show 2 open and closing that out. Feel free to open a support case.
Joshua & Ocean,
Every marketplace has the option to allocate or reserve quantity - only eBay requires it be set as such. Likely during your implementation you set your Amazon quantity to "allocate" - you can find this setting under Marketplaces>Amazon>Settings choose the action option to "edit" and look at the third set of radio buttons. More information and screenshots can be found here.
-Jennifer
Thanks Jennifer. Will CA soon have the functionality to not have to allocate eBay inventory? There are probably a lot of challenges to the eBay API that I'm not aware of, but it would be great if inventory feeds/sync for eBay can work like it does for Amazon and Buy.com.
Ocean
Ocean,
We are working on doing exactly that. There are many pieces involved in the project but we can break it down into two buckets - a) make eBay work more like Amazon and b) allow eBay quantity to not be allocated. Both are large sub-projects and we are currently planning to do part a first. What is your perspective?
-Jennifer
That's a great idea Jennifer. I feel bad for hijacking Joshua's thread, so I sent you an email with my thoughts.
See you at Catalyst
Ocean