Custom Inventory Calculation

SellerCloud can send a custom quantity value to a channel, based on a series of rules or special logic. Each time SellerCloud wants to send an inventory quantity for a specific product, it will run it against these rules to determine the right value to send.

A SellerCloud technician can create this calculation at the database level using a stored procedure, and this only requires enabling the channel(s) Client Setting Enable Customer Inventory Calculation for [Channel]. There is a separate stored procedure for each channel.

Attached below are several sample SQL scripts used for Amazon.com:

  • Sample 010: Client didn't want to offer a Fulfilled By Merchant listing if that same listing has an active Fulfilled By Amazon offering with available inventory. SellerCloud already knows which FBA listings have positive inventory, and looks that up while sending inventory for the MFN listings, and zeroes them out until the FBA listing runs out of stock. We also need to only consider FBA inventory from the same country, and total the FBA inventory that could be distributed between multiple SKUs.

  • Sample 011: Client wanted the FBA inventory to be considered sellable and included in the aggregate quantity for selling on eBay, but when sending MFN inventory, doesn't want to include it.

  • Sample 012: Client wanted the FBA inventory to be considered sellable and included in the aggregate quantity only if a checkbox was selected on each product. We check if IsFBASellable and decide whether or not to include the FBA inventory.

  • Sample 013: Client wanted to allocate percentages for each channel, so we show a page where they can configure each percentage, and the stored procedure considers that while calculating inventory to send to the channel.

In a product's Amazon or eBay Properties, this calculator icon lets you know that this feature is enabled:

Attachments:

CustomInventoryCalculationSample_010.pdf
CustomInventoryCalculationSample_011.pdf
CustomInventoryCalculationSample_012.pdf
CustomInventoryCalculationSample_013.txt


How did we do?