Setting Amazon / eBay inventory

There are two ways to control inventory.

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 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

Wen Fixed Quantity is selected, the value entered in the Input field is made available for sale on 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 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.


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 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