Skip to content
  • There are no suggestions because the search field is empty.

Step 2: Setup of Inventory/Products

The first step in getting setup in the Logicbroker Portal involves setting up your products for inventory transmission to your channel/retailer. 

✨Tip:

Not all retailers/channels are capable of receiving inventory feeds. It is best to always check with your partner to verify their requirements.

You can send inventory to Logicbroker by importing a CSV or XLSX file in the Portal, by sending an EDI 846 document, or through the API or a connector such as Shopify. This article covers importing files in the Portal. To send inventory automatically through EDI, the API or a connector instead of importing files by hand, contact Logicbroker Support.


Your SKU and the retailer's SKU

Logicbroker stores each item under your SKU. In inventory files this is the SupplierSKU column, and the Inventory page shows it as Supplier SKU. The retailer knows the same item by its own SKU. In files this is the MerchantSKU column, and the Inventory page shows it as Retailer SKU.

An item that has both SKUs is matched. An item with no Retailer SKU is unmatched. Logicbroker keeps unmatched items, but it normally shares only matched items with the retailer. This stops Logicbroker from sending items that the retailer has not set up. Some retailers receive unmatched items too, and their systems can reject items that have no Retailer SKU. Send inventory only for items the retailer has set up.

After an item is matched, your inventory files only need the SupplierSKU. Logicbroker keeps the Retailer SKU even if your file leaves it out.

Some retailers also send orders to you based on your matched items. An order for a retailer SKU that is not matched to one of your SKUs fails. See Order failed with "Merchant SKU not mapped" or "Failed to source items".

✨Tip:

IMPORTANT: Not all users are required to load a matching file. Before starting the matching file process, confirm with Logicbroker Support whether the retailer or supplier should be loading the matching file. 

Some retailers identify items by UPC rather than by their own SKU. To see the fields your retailer needs, go to Inventory, click Import, select the retailer and click Review Retailer's Requirements. If you do not know the retailer's SKUs for your items, contact the retailer or Logicbroker Support.

To load or change Retailer SKUs with a matching file:

  1. Go to Inventory and click Import. If you don't see Import, ask a teammate who has permission to manage inventory.
  2. Under Partner, select the retailer.

    2020-10-27_16-44-36.jpg

  3. Under Templates, click Matching SKU Feed Template. The CSV file has two columns, SupplierSKU and MerchantSKU.
  4. Enter your SKU and the retailer's SKU for each item, one item per row. Logicbroker skips rows with an empty MerchantSKU.

  5. Under Feed Type, select Matched SKUs Feed.
  6. Drag your CSV or XLSX file into Upload File, or click inside the box to choose it. Then click Import.

    2020-10-27_16-47-22.jpg

  7. Go back to Inventory and open the Events tab. A Matching File Imported event shows how many records Logicbroker imported. A Matching File Import Error event gives the reason the file failed.

To see which items are matched, go to Inventory, open the Feed tab, select the retailer and click Matched SKUs or Unmatched SKUs. To download your unmatched items, click Export on the Inventory page and choose Unmatched SKU Feed.

✨Tip:

Some accounts can turn on Auto Match SKUs under Inventory > Settings. With it on, Logicbroker sets the Retailer SKU to your Supplier SKU for every item you import, so you don't need a matching file. Use it only when the retailer's SKUs are the same as yours, and confirm with Logicbroker Support before you turn it on. Auto Match SKUs replaces the Retailer SKU each time you import. Leave it off if any of the retailer's SKUs differ from yours.

Importing inventory

After your items are matched, import your quantities and other item details:

  1. Go to Inventory and click Import.
  2. Under Partner, select the retailer.
  3. Under Templates, click Inventory Feed Template to download a CSV file. To see the fields your retailer requires, click Review Retailer's Requirements under Specifications. If the retailer has published its own EDI 846 specifications, an EDI Specifications link also appears there. For more details on all the field attributes and the standard, see the Inventory Specification under the Document Standards section.
  4. Fill in the SupplierSKU and Quantity for each item, and any other fields your retailer needs.
    • Format the UPC column as Text before you enter UPCs. Spreadsheet programs can change long numbers when you save. See Import shows "appears to contain scientific notation".
    • Some retailers use only some fields from your inventory, such as SKU, UPC and quantity. These retailers manage prices and item details, such as units of measure, in their own system. To change those, contact the retailer.
  5. Under Feed Type, select Inventory Feed. Select Custom Feed (Not Common) only if Logicbroker has set up a mapping for your own file format. To learn more about setting up a custom CSV or XLSX format contact support.
  6. Drag your CSV or XLSX file into Upload File, or click inside the box to choose it. Then click Import.
    • If Logicbroker finds a possible problem in the file, a Validation Warnings message lists it. Click Cancel, fix the file and import it again.
    • When the upload works, an Import Complete message says "Files uploaded, the import has been queued for processing."
  7. Check the result on the Events tab. See Checking that your inventory was processed and sent.

Each file updates only the items in it. If you leave an item out of a file, Logicbroker keeps its last quantity. The exception is the Send Latest Feed Only to the Retailer setting described below. To stop selling an item, send it with a quantity of 0. See Zeroing out, deleting and unmatching items.

Logicbroker checks your file against any inventory rules your retailer has set. It does not check whether your SKUs exist in the retailer's system.

Checking that your inventory was processed and sent

Go to Inventory and open the Events tab. It lists your imports and any errors, newest first. Select the retailer to see Last File Imported On and Refreshed Items. Click View on an event to see its details. If a file is attached to the event, you can download it there.

2020-10-27_17-16-42.jpg

The Summary column tells you what happened:

  • Inventory Imported means Logicbroker imported the number of records shown in the details.
  • Empty Inventory File means Logicbroker found no valid records in the file. Check that the file has a header row and a SupplierSKU on every row. If Ignore Un-matched SKUs is on, Logicbroker also skips every item that is not matched.
  • Inventory Import Error means Logicbroker could not import the file, or some items broke your retailer's rules. The details give the reason. For rule errors they say "Items failed validation in inventory file" and point you to the report. Fix the rows and import the file again.
  • Matching File Imported and Matching File Import Error are the results of a matching file.
  • Inventory Sent via EDI means Logicbroker sent your inventory to the retailer. The details show how many items it sent. You see this event only for retailers that receive inventory this way. Other retailers receive or collect inventory in other ways.
  • Inventory Upload Failed means Logicbroker could not send your inventory to the retailer. Contact Logicbroker Support with the event details.

Based on the partner you are integrating with Logicbroker will send the inventory update on a periodic basis. This differs between channels/retailers, but typically will send at least once every 24 hours. The inventory feed will only send updated products from the last transmission to the retailer. 

For example, if you had 100 products setup, and sent 2 feeds, one updating 25 and 50 in the other; the next update sent to your partner will show 75 products in the inventory update.

✨Tip:

If Send Latest Feed Only to the Retailer is on, each import replaces the ones before it. After each import, Logicbroker sets every item that is not in that file to a quantity of 0. Use this setting only if every file you send includes all your items for that retailer.

Downloading your current inventory

To download the inventory that Logicbroker holds for a retailer, go to Inventory and click Export. Under Partner, select the retailer. Choose a Feed Type and an Export Format (CSV or XLSX), then click Export. The Export files section below describes each feed type.

Use the export to check what Logicbroker holds for the retailer, or as the starting point for your next import.

Zeroing out, deleting and unmatching items

These actions change what the retailer receives in different ways:

  • Zero out. Sets the quantity to 0. The item and its Retailer SKU stay in Logicbroker, and Logicbroker includes the 0 in its next update to the retailer. To make the item available again, send a positive quantity. Use this when an item is out of stock or discontinued.
  • Delete. Removes the item from Logicbroker, so the retailer gets no more updates for it. The retailer may keep the last quantity it received. Zero out the item first, and confirm with the retailer how it wants you to discontinue items. Also remove the item from your future files. If the item is in a later file, Logicbroker adds it again.
  • Unmatch. Removes the Retailer SKU and keeps the item and its other details. Logicbroker no longer shares the item with the retailer, so the retailer may keep the last quantity it received. Use this when Retailer SKUs are wrong, then load a corrected matching file.

For one or a few items, go to Inventory, open the Feed tab and select the items. To zero them out, click Bulk Edit, then Zero Out. To unmatch or delete them, click Unmatch or Delete. To act on every item for a retailer, use Quick Bulk Actions on the Import page. The Quick Bulk Actions section below describes each action. Some accounts don't see Unmatch, Delete All Items or Clear All SKU Matches.

Some retailers remove an item from their site when its quantity is 0 and show it again when you send a positive quantity. Check your retailer's process for discontinued items before you delete them.

Items show as unmatched or don't reach the retailer

Who this applies to. Suppliers who send inventory for a retailer that uses Retailer SKUs. It applies whether you import files, send EDI or use the API, because matching happens in Logicbroker.

What it means. The item has no Retailer SKU, so Logicbroker normally does not share it with the retailer. Usually nobody has loaded a matching file for new items, or the Supplier SKU in your inventory is not the same as the one in the match.

What to check:

  1. Go to Inventory, open the Feed tab, select the retailer and click Unmatched SKUs. You can also export the Unmatched SKU Feed.
  2. Compare each Supplier SKU with the SKU in your matching file. They must match character for character. Logicbroker ignores letter case unless Enable Case-sensitvity is on.
  3. Check that the retailer has set up the item. If the retailer has not set it up, leave it out of your inventory for that retailer.

The fix. Load a matching file with the SupplierSKU and MerchantSKU for these items. See Your SKU and the retailer's SKU. If the Retailer SKUs are wrong, unmatch the items first, then load the corrected matching file. After the items are matched, import your inventory again so the retailer gets the current quantities.

How to check it worked. The Events tab shows Matching File Imported, and the items appear under Matched SKUs on the Feed tab.

When to contact Support. Contact Logicbroker Support if you don't know whether you or the retailer loads the matching file, or if items stay unmatched after a successful matching file. Include your company name, the retailer, the Supplier SKUs, and the file name and time from the Events tab.

Order failed with "Merchant SKU not mapped" or "Failed to source items"

Who this applies to. Suppliers whose retailer uses Logicbroker inventory to send orders to suppliers. The retailer may contact you about the failed order.

What it means. The order has a retailer SKU that is not matched to any Supplier SKU, so Logicbroker could not send the order to a supplier. The error says "We are unable to source your order because the merchant SKU '...' is not matched to a supplier SKU. Please upload an updated matching file and retry this order." or "The following items could not be sourced:" followed by the SKUs.

What to check:

  1. Note the retailer SKUs in the error.
  2. Go to Inventory, open the Feed tab and filter the Retailer SKU column for each of them.
  3. If you find no item, find your item by its Supplier SKU and check whether it is unmatched or has a different Retailer SKU.

The fix. Load a matching file that gives your Supplier SKU the retailer SKU from the error. Then ask the retailer or Logicbroker Support to retry the order.

How to check it worked. Your item shows the retailer SKU on the Feed tab, and after the retry you receive the order.

When to contact Support. Include your company name, the retailer, the PO number, the exact error, the SKUs and the time you loaded the matching file.

Import shows "appears to contain scientific notation" or UPCs changed to 750000000000

Who this applies to. Suppliers who import CSV or XLSX files in the Portal.

What it means. A spreadsheet program has shown long numbers, such as UPCs, in scientific notation (for example 7.5E+11). When you save, the file can keep the rounded number, so every UPC becomes a value such as 750000000000. Retailers that use UPCs cannot list or match items with wrong UPCs. The Portal warns you with a Validation Warnings message that says "There is a possible issue in this file." and "Column UPC appears to contain scientific notation." with a sample value.

What to check:

  1. Read the column name and sample value in the message.
  2. Open the file and look at that column. If the values end in many zeros or show "E+", the original digits are lost.

The fix. Click Cancel. Format the column as Text, enter the correct values from your own system and save the file. Then import it again. If you already imported a file with wrong UPCs, import a corrected file with the right UPC for every affected item.

How to check it worked. The import shows Import Complete with no Validation Warnings, and the Events tab shows Inventory Imported. Export the Inventory Feed and check the UPC column.

When to contact Support. Contact Logicbroker Support if the retailer still reports wrong UPCs after a corrected import. Include your company name, the retailer, a few affected SKUs and the file name and time from the Events tab.

A discontinued or zeroed item still gets orders

Who this applies to. Suppliers who have zeroed out or stopped sending an item. What the retailer does with a quantity of 0 varies by retailer.

What it means. The retailer still has a positive quantity for the item. Common causes are that the item was left out of your file instead of being sent with 0, another file or system updated the item after you zeroed it, or the item was deleted before it was zeroed.

What to check:

  1. Go to Inventory, open the Feed tab and find the Supplier SKU. Check Quantity and Refreshed within. Hover over Refreshed within to see the exact date and time.
  2. Open the Events tab and look at the imports around that time. The details show who imported how many records and from which file. Click View on an import. If the file is attached, download it to see what it contained. Look for files you did not expect, such as a file sent from a test system.
  3. Check whether your regular inventory file includes the item.

The fix. Send the item with a quantity of 0 in your next file or EDI update, or select it on the Feed tab and use Bulk Edit > Zero Out. If an unexpected file changed the quantity, stop that file at its source. Keep sending 0 until the retailer shows the item as unavailable. Then remove it from your future files.

How to check it worked. The Feed tab shows a quantity of 0 with a recent Refreshed within time. For retailers that receive inventory by EDI, the next Inventory Sent via EDI event follows.

When to contact Support. Contact Logicbroker Support if you deleted the item before you zeroed it, or if the quantity changes without an import you recognize. Include your company name, the retailer, the Supplier SKUs, the PO numbers of the orders you did not expect and the time you sent the 0.

The sections below describe the inventory settings, the Quick Bulk Actions and the export files.

Inventory settings

Some accounts see a Settings button on the Inventory page. Select the retailer under Select Partner, change a setting and click Save Changes. If you aren't sure about a setting, confirm with Logicbroker Support before you change it.

Clear SKUs from Feed After
Sets the quantity to 0 for items you have not updated within the selected period of 7, 30 or 60 days. The items stay in Logicbroker. Use it to stop old quantities from reaching the retailer.
Minimum Quantity
When you import a quantity at or below this number, Logicbroker sets it to 0.
Allocation
If you are sending the same inventory counts across all your partners, you can set an allocation percentage for each partner. If you select 50%, and submit an inventory count for an item of 20, the update sent to your partner will be 10.
Auto Match SKUs
Sets the Retailer SKU to your Supplier SKU for every item you import, so every item on your feed is sent to the retailer. Use it only when the retailer's SKUs are the same as yours. To give an item a Retailer SKU that is different from your SKU, leave this off and use a matching file.
Ignore Un-matched SKUs
Logicbroker skips items in your file that are not matched, so they don't appear as unmatched. Use it when your file includes items that are not meant for this retailer.
Enable Case-sensitvity
Logicbroker changes all SKUs to uppercase unless this is on. Turn it on when your SKUs or your system are case-sensitive.
Send Latest Feed Only to the Retailer
After each import, Logicbroker sets every item that is not in that file to a quantity of 0. The Events tab shows how many items it changed. Use it only if every file you send includes all your items for this retailer.
Quick Bulk Actions

Go to Inventory, click Import and select the retailer under Partner. Quick Bulk Actions appears if you have permission to manage inventory. Each action applies to every item for the selected retailer and adds an event on the Events tab.

Zero out Items
Sets the quantity of all items to 0. The items and their Retailer SKUs stay. This action cannot be undone.
Delete All Items
Selecting this will remove all item information setup for your partner, including the Retailer SKUs. Zero out the items first, or the retailer may keep the last quantities it received.
Clear All SKU Matches
Removes the Retailer SKU from all items and keeps all other information. Use this if incorrect Retailer SKUs were set up on your items, then load a corrected matching file. Until you do, updates for these items may not reach the retailer. This action cannot be undone.
Reupload All Items
Marks all items that have a quantity as updated, so Logicbroker includes them in its next update to the retailer. It also updates Refreshed within. Use it only if nothing has changed since your last file.
Export files
Inventory Feed
All matched items that Logicbroker shares with the retailer, with every field Logicbroker supports. For more information on these fields see the Inventory Specification page.
Retailer Feed
All matched items that Logicbroker shares with the retailer, with only the retailer's fields.
Unmatched SKU Feed
All items that have no Retailer SKU. If Auto Match SKUs or Ignore Un-matched SKUs is on, this file is usually empty.

We're updating this article. Some steps and screenshots may not match the portal yet. If anything is unclear, contact support@logicbroker.com.