Inventory Updates

Overview
This guide will detail features that are common to most channel configurations for Inventory updates.

Table of Contents

Price Change

Price Change is designed to automate the process of updating the sales channel once a Linnworks stock item has had its listing price updated and saved. The Price Change feature (when enabled in your config channel) will pass updates regardless of the method used to change them (Scripts, automated and manual imports, manual changes and Direct Database updates), under the assumption that Price has a specific Source and SubSource value for that channel.

Please Note! For Price Change to function, Channel must be enabled. If Inventory Sync is disabled, Linnworks will still send the price to the channel.

Enabling Price Change

For demonstration purposes of describing how Price Change works, we will use eBay.

For Price Change to operate, the option must first be enabled for the required sales channel

  1. Go to Settings > Channel Integrations
  2. Click on the pencil icon to edit the required channel config
  3. Tick Price Change in the Inventory section to enable the option
  4. To update and close the config click the Save button at the bottom
  5. All subsequent channel specific price changes will be automatically scheduled and submitted to the enabled channel

How Price Change works

Price Change is designed to work with the Channel specific price that is defined under the Listing Description tab for an Inventory Item. This guide will show how to access this tab and manually adjust an eBay channel price

  1. Go to Inventory > My Inventory
  2. Select the required Inventory item by clicking on the relevant product in the SKU column
  3. Select the Listing Descriptions Tab
  4. Edit the price for the appropriate eBay channel, e.g. EBAY0_UK change price from 18.50 to 17.50
  5. Click Save to apply the changes
  6. Linnworks will submit the change to the queue of updates to push to eBay

Price Change Statuses

Status Icon Description
  Save Required: The price won't be submitted until you save the changes you have made to the stock item
  Pending: The price is waiting to be submitted, or Linnworks is waiting for the channel to confirm that the submission was successful
  Success: The channel has confirmed the price change was received successfully
  Error: An error caused the price sync to fail. For more information, check your Automation Logs
  No Change: The price has not changed, so no submission is required

Special Criteria

In general, all channels work in the same way for this functionality, but there are a few exceptions that are detailed below

Standard Format for most channels

A price for the required Source and Subsource combination must be added to the Listings Descriptions tab

  • Source - The Channel name as displayed when hovering over the icon in the Channel Integration screen, for example, "GAME"
  • Subsource - The that was used when setting up the channel in the first place and is displayed in the Name column in the Channel Integration screen, for example, "GAME1"

Special cases

Amazon

Amazon Pricing allows both a normal price and a sale price to be submitted. There are two ways that a price can be submitted

  • Main Price - supply the channel [Source] and [SubSource]
  • Main Price and Sale Price - Supply additional Sale price with [Source] and [SubSource_SALE]

A Sale price cannot be submitted on its own

It is also possible to offer Amazon Business Prices. For more information, please see this guide.

Cdiscount

The price change is enabled by default for Cdiscount integrations that use inventory sync to update product stock levels. This is due to Cdiscount requiring prices to be submitted with stock updates.

eBay

Automatic eBay Price Change only work where the country-specific code has been added as part of the SubSource in the Listing Price

  • e.g. EBAY0_UK or EBAY0_FR
  • EBAY0 by itself will not work

When working with multiple languages, the price for the appropriate sub source must be modified, e.g. in the example shown France would be EBAY0_FR

Etsy

When working with variation listings on Etsy it is possible to have different prices for the child items, but it is important that understand how Etsy manages the price differentials for variation child items. On Etsy, only one of the Variation specifics is used to control the price so that all variation children with the same variation specific value have the same price. This is explained in more detail in the Rules & Guidelines document for Etsy

Jet

Price update will happen if the Price change is ticked and a relevant entry exists on the inventory Item screen for Jet prices. A drop-down list will become available when setting Jet prices, that will allow you to chose from the specified Jet's location where the price that is sent from Linnworks needs to be updated.

Magento

For price change to function the Linnworks Extension must be installed on your Magento store

Tesco

For price change to function the Tesco Listing must have been generated through the Linnworks Tesco Listing tool. Due to the nature of the information that is required to perform a price update on Tesco, it is not possible to apply this to listings directly generated on the Tesco platform as Linnworks does not hold all of the properties required by Tesco. 

Shopware

Price update will happen if the Price change is ticked and a relevant entry exists on the mapped Linnworks item with the relevant source and subsource. The price that is sent from Linnworks will only update the first price (From 1 to ...), if the item has more than one price set on Shopware, the other prices will remain as they are. 

Walmart

Walmart Pricing allows a normal price and promotional prices to be submitted. There are two ways that a price can be submitted

  • Main Price - supply the channel [Source] and [SubSource]
  • Main Price and Promotional Prices  - Any promotional prices cannot be submitted on their own. Find more information on Rules and Guidelines for Walmart.

To add a Promotional Price to a stock item, please do the following:

    • Search for the item in My Inventory and click the SKU to open the Product Details window
    • Open Listing Descriptions and click Add New
    • Add the following information into the pop-up window:
      •  Source: WALMART
      •  SubSource: The SubSource name as it appears in the Channel Integration screen
      •  Price: Your Reduce or Clearance price for the item
      •  Tag: This must be set to REDUCE/REDUCE_COMPARE or CLEARANCE or CLEARANCE_COMPARE. Leaving this TAG blank will offer this SKU at the main price
    • Click Add to save
      • These prices are not saved to the stock item until the Save button on the Product Details window is clicked

Remember, main price(s) must be added to your Linnworks stock items in order to promotional prices to work.

WooCommerce

There are two prices that can be configured on a Woocommerce site; regular_price and sale_price. As part of a price change job, Linnworks will only update the regular_price. If a product has a sale_price defined on your Woocommerce store, the updated regular_price may not be displayed.

Submission

When manually changing prices as described in the example above (How Price Change works) these changes are submitted to the channel on an individual basis, so the actual update on the channel can potentially happen within 5 minutes dependant on how quickly the channel reacts to the submission

However, it would be more common to make price changes in bulk via Data Import and then have Linnworks.net submit these changes to the channel. In this case, some channels allow Linnworks to push all the updates in a single submission, but for others, it is a requirement to break the submission down into several batches. The table below provides a breakdown of the batch size and submission progress.

Channel Batch Size Linnworks Process Time per Batch Linnworks Process Time for 20K update (approx)
Amazon 10,000 Up to 30 minutes 1 hour
CDiscount 500 Up to 30 minutes 20 hours
eBay 250 Up to 30 minutes 40 hours
Etsy 500 Up to 30 minutes 20 hours
External 10,000 Up to 30 minutes 1 hour
Flubit 1,000 Up to 30 minutes 10 hours
Game 10,000 Up to 30 minutes 1 hour
Gameseek 10,000 Up to 30 minutes 1 hour
Hitmeister (Real.de) 10,000 Up to 30 minutes 1 hour
Magento 100 Up to 30 minutes 100 hours
NewEgg 10,000 Up to 30 minutes 1 hour
Jet 500 Up to 30 minutes 20 hours
Shopify 10,000 Up to 30 minutes 1 hour
Tesco 2,500 Up to 30 minutes 4 hours
Woocommerce 3,000 Up to 30 minutes 3.33 hours
3Dcart 1,000 Up to 30 minutes 10 hours
Walmart 1,000 Up to 4 hours 90 hours
Channel Update timing It is not possible for us to provide an estimate for Channel Process Time per Batch to reflect the update on the channel as this process is controlled by each channel and is dependant on their own server loads and systems architecture

View Logs

It is possible to keep a track on the progress of these submissions through our Automation Logs; this could be crucial if you have imported a large number of updates and would like to work out how far through Linnworks has reached. The logs also report any errors that were found during the price update

  1. Goto Settings > Automation Logs
  2. Select the required Job Category from the drop-down list, e.g. eBay
  3. Select the required Job Type of Price Change from the drop-down list
  4. An overview of the logs for the defined date range will be displayed
  5. Double click on the row to display a list of each execution for the specific Log
  6. This displays the start and end time of each execution along with the overall duration of the execution
  7. Clicking View Log will display a breakdown of the tasks completed during the execution similar to this
  8. If any errors occurred during the execution, an additional button is displayed to highlight and show how many errors were reported
  9. Clicking on the error(s) button will display more detail on the nature of the reported error similar to this

Max Listed

This specifies the maximum level that will be sent to the channel.

      • The level published will never be higher even if there is more stock within Linnworks
      • Example
        • Max Listed Quantity = 10
        • Linnworks Stock Level = 20
        • Therefore ~ Listed Quantity = 10
      • To use individual levels instead of a global value refer to the following guide on Stock Item Linking

Stock Percentage

This will send a percentage of the existing available stock level to the sales channel

      • Works similarly as Max Listed but rather than a fixed number, you are stating a % of your total inventory.
      • For example, if you have 10 in stock and set the percentage to 50, 5 will be sent to the channel.
      • Please be aware that Linnworks will always round down.
      • Example 1
        • Default Max Listed Quantity = 0
        • Linnworks available stock level = 12
        • Default Max Listed Percentage = 60
        • Therefore ~ Listed Quantity = 7 as 60% of 12 = 7.2
      • Example 2
        • Default Max Listed Quantity = 50
        • Linnworks Available Stock level = 60
        • Default Max Listed Percentage = 75
        • Therefore ~ Listed Quantity = 45 as 75% of 60 = 45 (less than Max Listed Qty)
      • Example 3
        • Default Max Listed Quantity = 50
        • Linnworks Available Stock level = 200
        • Default Max Listed Percentage = 75
        • Therefore ~ Listed Quantity = 50 as 75% of 200 = 150 (greater than Max Listed Quantity)
      • To use individual levels instead of a global value refer to the following guide on Stock Item Linking

End When

This enables you to force the listing to end when the stock level gets to the specified amount as opposed to the default value of zero

    • Eg. If you set this to 3 and only have 3 items left in stock then it would end the listing on Shopify.
    • Helping to give you a stock buffer so that you don't run out or oversell
    • Example
      • Default End When Quantity = 5
      • Linnworks Available Stock Level changes from 6 to 5 due to an order
      • Therefore the listing on Shopify is ended early, leaving stock available for other sales channels
    • End When works in conjunction with Max Listed Qty and Stock Percentage Qty if set up
      • End When Qty must always be lower than Max Listed Qty
      • If calculated Stock Percentage is lower than End When the listing will be ended
    • To use individual levels instead of a global value refer to the following guide on Stock Item Linking