As a multichannel solution, Ordoro has tools to manage your inventory. The Product/Sales Channel Bridge export identifies which channels a product is listed on, channel-specific data, etc.
Once you open the export, you can edit the data and easily re-upload it to Ordoro to make bulk changes.
Topics
- How to export the Product/Sales Channel Bridge report
- What’s in the Sales Channel Bridge export?
- How can I use the report?
How to export the Product/Sales Channel Bridge report
1. Go to the Products tab.
2. Select Other Actions -> Export Product/Sales Channel Bridge.
3. Select the Activity menu and select Exports.
4. This will take you to the Reports Activity Log. You’ll see the Export Product/Sales Channel Bridge download at the top of the list. Click CSV to download the report.
What’s in the Sales Channel Bridge export?
The following columns are in the file.
- SKU
- Sales Channel Name
- Amazon Fulfillment Channel
- Product Level Fulfillment Latency
- Max Export Quantity
- Writeback Inventory
- Created
Let’s discover what each does!
Column heading: SKU
- This is the product SKU saved in Ordoro.
- Ordoro uses the SKU as the unique identifier to manage products.
Column heading: Sales Channel Name
- What you’ve named the cart or marketplace in Ordoro.
- You’ll see the corresponding name in Settings -> Sales Channels.
Column heading: Amazon Fulfillment Channel
- What is Amazon Fulfillment Channel?
- If the item is tied to Amazon, this column lists if it’s Fulfilled by Merchant (FBM) or Fulfilled by Amazon (FBA).
- If the SKU is Fulfilled by Merchant (FBM), the report will list DEFAULT.
- If the SKU is Fulfilled by Amazon (FBA), one of these will be in the column:
- AMAZON_NA = North America
- AMAZON_EU = Europe
- AMAZON_CA = Canada
- See this help article for details about updating the Amazon Fulfillment Channel.
Column heading: Product Level Fulfillment Latency
- What is Fulfillment Latency?
- Also known as Handling or Production Time, latency specifies the number of days to ship orders once they have been placed.
- Generally, the default value is 1-2 business days.
- Only Amazon SKUs will have this in Ordoro. Other cart’s latency is not currently supported.
- If you’ve set a value on the product level, it will appear in this report.
- If the value is blank, no latency has been set for this product, and it will use the cart level setting.
- See this help article for info about latency.
Column heading: Max Export Quantity
- What is Max Export Quantity?
- A Minimum Export Quantity will tell your sales channels that there is a minimum amount of inventory at all times.
- If you have more inventory in your warehouse than the Max Export Quantity, Ordoro will sync the Max Export Quantity to your sales channel.
- If you have less inventory in your warehouse than the Max Export Quantity, Ordoro will sync the inventory that you have Available On Hand.
- Example:
- Available on Hand = 0
- Max Export Quantity = 5
- Ordoro will Sync 0 to your sales channel.
- Alternate Example:
- Available on Hand = 10
- Max Export Quantity = 5
- Ordoro will Sync 5 to your sales channel.
- A Minimum Export Quantity will tell your sales channels that there is a minimum amount of inventory at all times.
- If you’ve set this quantity on the product level, it will appear in the report.
- If the value is blank, no Max Export Quantity has been set, and Ordoro will send the total Available on Hand to your sales channels.
- See this help article to learn about the Max Export Quantity and how it interacts with other inventory sync alterations.
Column heading: Percentage Writeback
- What is the Percentage Writeback?
- A Percentage Writeback will sync a percentage of the Available on Hand inventory to your sales channel.
- Example:
- Available on Hand = 10
- Percentage Writeback= 75
- Ordoro will Sync 7 to your sales channel.
- Ordoro will round down to the nearest full number. In the example above, instead of syncing 7.5, Ordoro rounds down to 7.
- Example:
- A Percentage Writeback will sync a percentage of the Available on Hand inventory to your sales channel.
- If you’ve set this quantity on the product level, it will appear in the report.
- If the value is 100, no Percentage Writeback has been set, and Ordoro will send the total Available on Hand to your sales channels (100% of your Available On Hand is synced back to your sales channels by default).
- See this help article to learn about the Percentage Export and how it interacts with other inventory sync alterations.
Column heading: Reserve Export Quantity
- What is the Reserve Export Quantity?
- The Reserve Export Quantity is a number of units you would like to reserve from selling on your sales channel.
- Example:
- Available on Hand = 10
- Reserve Quantity = 4
- Ordoro will Sync 6 to your sales channel.
- Example:
- The Reserve Export Quantity is a number of units you would like to reserve from selling on your sales channel.
- If you’ve set this quantity on the product level, it will appear in the report.
- If the value is blank, no Reserve Export Quantity has been set, and Ordoro will send the total Available on Hand to your sales channels.
- See this help article to learn about the Reserve Export Quantity and how it interacts with other inventory sync alterations.
Column heading: Calculated Available On Hand
- What is the Calculated Available On Hand?
- This column tells you what your expected Inventory Writeback to your sales channel will be based on your current settings.
- See this help article to learn about the Calculated Writeback Quantity and how it interacts with other inventory sync alterations.
Column heading: Writeback Inventory
- What does Writeback Inventory mean?
- By default, when your inventory quantities change in Ordoro, it updates the carts.
- However, you can disable sending inventory per product and sales channel.
- This may be helpful if you want to keep a product live on Amazon but have deleted the eBay listing.
- In this case, you’d set Writeback Inventory = FALSE for eBay.
- If TRUE, Ordoro is writing back inventory for this item to the cart.
- If FALSE, Ordoro does not write back inventory to the cart for this product.
- See this help article for details on writing back inventory per product.
Column heading: Created
- What does Created mean?
- This is the date Ordoro connected this SKU with the cart.
- In the image below, the SKU krull-dvd was first linked to Ordoro on July 17, 2020, via Shopify.
- Therefore, the description, initial inventory, weight, images, etc. were set by this connection.
- Subsequent carts were added but did not change those values.
- These connections usually happen when a product import task runs. Occasionally it’s because the product was on order.
- This column is helpful to determine when items were initially imported to Ordoro.
How can I use the report?
- The report can be used to edit data and quickly upload via our Data Import feature.
- This export corresponds to the Update Product/Sales Channel Bridge import. See the screenshot below.
- The column headings are will automatically map for ease of use.
- If you’re comfortable with Excel, you can use a pivot table to find how many sales channels a SKU is tied to. See the image below.
- In the example, SKU krull-dvd is tied to all five of my carts. However, bladerunner-dvd is only on two.
- I analyzed the report to determine which channels were missing and then created those listings.
