Setting Amazon / eBay inventory

Why is it so important? When selling multi-quantity items on your website, Amazon and eBay, it becomes more important than ever to have an effective inventory management strategy in-place. Doing so gives you greater control over where and how your products are made available, prevents you from selling items you no longer have in-stock, and ensures a quality buying experience across all channels.


Codisto gives you more control of your inventory

Depending on your multichannel inventory management strategy, you may need to limit or even maximize inventory across your channels. Managing inventory in Codisto does not make any changes to your website, only to eBay and Amazon.


There are two ways to control inventory in Codisto.

1) Via the Xpress Grid Quantity column operators

2) Via Custom Attributes:

i) a formula e.g. If web quantity is greater than 5, list with 5 else list with the web quantity (this sets a stock limit or maximum quantity and can be useful to get around account listing limits on Amazon/eBay or make stock look more scare than it is). But all sorts of formulas are possible - this is just an example.

ii) a constant value e.g. always list with 1 (effectively ignoring automatic stock decrementing)

iii)specific values from another data source in your ecommerce platform defined as an attribute.


1) XpressGrid Quantity Column

The quantity of items available on eBay is controlled by a combination of settings in XpressGrid. 

The images show "eBay Quantity" columns. The concepts are identical for Amazon.

By default the quantity available will be "Web Quantity", which is the quantity available for sale on the website.


When Quantity column in XpressGrid is collapsed (the default) it shows the listed quantity.


Expanding the Quantity Column shows the available options.


Web Quantity

When Web Quantity is selected, the Result column will show the quantity available for sale on the website. This is the default. Updating the Input field in this mode has no effect.

Fixed Quantity

When Fixed Quantity is selected, the value entered in the Input field is made available for sale on Amazon/eBay. This setting ignores the stock on hand, so it should only be used if you are always able to secure stock to fulfil if you run out of stock.

Quantity Buffer

The Quantity Buffer makes it possible to list just some of your stock on Amazon/eBay. It will reduce the web quantity by the amount entered in the Input field. For example, if you have 25 in stock, select Quantity Buffer and enter 15 into Input, the Result is 10.

Max Quantity

Limits the quantity to the value in the Input field. For example, if you have 25 in stock, select Max Quantity and enter 5 into Input, the Result is 5, but any less in stock, the result is the stock level.

2) Via Custom Attributes

Navigate to "Manage Attributes" (next to the Manage Orders menu item at the top).

Within Sales Attributes you will find Quantity.  Here you can map to a custom attribute you have created, select Constant and enter a value or Select and enter a formula.   The image below is from Shopify for Amazon/eBay but the concept is the same for Magento, WooCommerce and Amazon - enter the value and click the green save button at the top.

To enter a formula for "If web quantity is greater than 5, list with 5 else list with the web quantity"

You would enter:

(quantity > 5) ? 5 : quantity

In this formula, '?' means "then" and ''' means "else".

Remember to Save and