Using the Listing Quantity Expression to Control the Quantities on Your Listings

This article will show you how to use the listing quantity expression to manage, and manipulate, the quantities we push to the marketplaces.

 

What we'll cover:

  1. An Explanation of the Listing Quantity Expression
  2. Valid Values and Best Practices for the Quantity Expression
  3. Managing Your Quantity Expressions Through a Spreadsheet
  4. Managing Your Quantity Expressions Through the User Interface
  5. Related Articles

 

An Explanation of the Listing Quantity Expression

The listing quantity expression (qty exp) is a formula that controls what quantity we submit to each marketplace. It can be used to submit your entire inventory or hide the actual stock level.

inventory_management_controlling_marketplace_qty_qty_exp_column_ui.png

The qty exp field is not the same as the quantity (qty) field. Quantity is the stock level found in a Warehouse or Vendor Inventory list. The qty field is about the Warehouse. The qty exp field is about the marketplace.

inventory_management_controlling_marketplace_qty_qty_column_ui.png 

 

Valid Values and Best Practices for the Quantity Expression

Qty Exp Options Option Descriptions
lq

lq stands for "list quantity," meaning the quantity in your Warehouse. If you use lq in the qty exp field, we will send your entire inventory to the marketplace.

EXAMPLE: You have a quantity of 21 in your Warehouse. A qty exp of lq instructs us to push a quantity of 21 to your marketplace.

lq-x

This formula allows you to withhold some of your inventory from the marketplace. x represents the number of items you want to withhold. This formula is useful if you'd like to create an inventory cushion on your listing to avoid overselling. Sometimes clients that use dropshippers take advantage of this feature.

EXAMPLE: You have a quantity of 21 in your Warehouse. A qty exp of lq-2 instructs us to send 19 (21-2) to the marketplace.

 x

x represents a fixed quantity that you want to maintain on your listing at all times.

EXAMPLE: You have a quantity of 21 in your Warehouse. A qty exp of instructs us to maintain a constant quantity of 3 on your listing. When an order is placed, the marketplace will reduce the quantity, but we will resubmit 3 as soon as we receive the order.

Important!

This option ignores the quantity in your Warehouse. That means that even when you have less inventory than the fixed number you're using as your qty exp, we will still push the fixed number. This can be useful if you can readily get more inventory and want to keep your listing live even after you run out of stock. However, if you want to avoid oversells, try the Inline IF option explained below.

If you want to keep eBay listings open even when you are out of stock, in your eBay Listing Rule, ensure that the Close listing when inventory is below box is unchecked.

IIF(lq>x,y,lq)

In this Inline IF formula, x represents the quantity in your Warehouse. y represents the number of items you want listed on the marketplace.

Here is how you read the formula: "IF the list quantity in my Solid Commerce Warehouse is greater than x, THEN push a stock level of y to the marketplace. IF the list quantity in my Solid Commerce Warehouse is not greater than x, THEN push my actual stock level to the marketplace."

This option is great for creating a sense of urgency in buyers and managing eBay selling limits.

EXAMPLE: You have a quantity of 21 in your Warehouse. If you use a qty exp of IIF(lq>3,3,lq), we will maintain a constant quantity of 3 on your listing until the quantity in your Warehouse is 3. After that, we will send the actual quantity to the market.

No matter which listing quantity formula you use, we will keep an accurate quantity count in your Warehouse.

NOTE:

Many marketplaces hide quantities from buyers. Amazon works this way. It's not necessary to use either of the bottom two qty exp options to hide stock levels from markets that already do that for you. The most popular marketplace to hide inventory from is eBay. This is because:

  • You can avoid reaching listing limits, which allows you to list more items.
  • You can hide your inventory levels from your competitors.
  • You can create a sense of urgency in your buyers.

 

Managing Your Quantity Expressions Through a Spreadsheet

1) If you only want to update your qty exp, create a new sheet with the following column headers: results, product custom sku, warehouse id, list name.

  • Also add the correct qty exp header. The name of the qty exp column header varies by marketplace. Here are the most common: ebay qty exp, amazon qty exp, walmart:qty expmystore qty expjet:qty exprakuten qty exp, and sears qty exp.
  • You can always click the Manage Excel Columns button in the Solid Commerce Excel menu for help. See Creating and Customizing a Solid Commerce Excel Template for more info.

inventory_management_controlling_marketplace_qty_qty_exp_excel_add-in.png2) After you populate your file, upload it with a Marketplace update.

Once your upload has processed, Solid Commerce will automatically send the correct quantity to the marketplace during the next cycle. You don't need to take any further action. Please note that the cycle may take up to 15 minutes.

 

Managing Your Quantity Expressions Through the User Interface

1) Navigate to the Inventory Manager and select the Market List containing the listings you want to work with.

2) Look for the Listing Qty Exp column.

3) Enter the formula you want to use in the Listing Qty Exp field.

4) Click the Save button that appears on the left, above your listings.

inventory_management_controlling_marketplace_qty_qty_exp_update_ui.pngSolid Commerce will automatically send the correct quantity to the marketplace during the next cycle. You don't need to take any further action. Please note that the cycle may take up to 15 minutes.

NOTE:

If the Listing Qty Exp column is not visible, click on the Columns Setup button. Check the Listing Qty Formula box and click the Apply and Close button.

 

Related Articles

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.