Introduction

If you need to override quantities or prices of a certain vendor or you want to curate the product catalog before publishing it to your store, you might need to create an additional inventory feed. 

In this article, we will walk you through this process to make sure everything is configured correctly in your account.

Disclaimer

It is not possible to have 2 inventory feeds connected to the same store URL and credentials. We typically recommend having one feed connected to the vendor's store and another one using a Google sheet, for instance.

For both scenarios, the setting "Automatically connect by SKU" under the Publishing tab should be enabled in the Google sheet/manual feed to ensure the connection between both feeds.

SCENARIO A: curate the vendor's product catalog

You may want to work on the product descriptions, variant colors and/or product titles to make sure they match the criteria of the catalog in your store. Follow this process if you need to curate your vendor’s catalog but still want to have stock and prices synced with their store.

How?

- Create 1 inventory feed for stock and/or price management by connecting directly with the vendor’s store.
- Create 1 inventory feed for catalog creation via Google sheet, for example.

Settings

- Feed #1- connected to the vendor’s store to sync stock/prices

• Mapping tab > select “Sync inventory levels or pricing” AND
• Mapping tab > select "Update inventory only" OR "Update inventory and pricing"
  

• Inventory and Prices tab > choose "Sync all inventory updates" AND/OR
• Inventory and Prices tab > enable "Sync pricing with your online store" (if you are using this feed to sync pricing from the vendor's store into your e-commerce platform)

- Feed #2 - file for product catalog creation

• Mapping tab > choose “Publish items to my online store” AND
• Mapping tab > choose “Product data for publishing”
  
  
• Inventory and Prices tab > choose “Don’t sync inventory” AND/OR
• Inventory and Prices tab > disable “Sync pricing with your online store” (if you're using feed #1 to sync pricing from the vendor's store into your e-commerce platform)
  
  

SCENARIO B: override vendor's stock and/or prices

If you need to override your vendor's stock and/or prices but still want to import the product catalog directly from their store, you can do so.

How?

- Create 1 inventory feed for catalog creation by connecting directly with the vendor’s store.

- Create 1 inventory feed for stock and/or price management via Google sheet, for example.

Settings

- Feed #1 - connected to the vendor’s store to import the product catalog

• Mapping tab > choose “Publish items to my online store”
  
  
• Inventory and Prices tab > choose “Don’t sync inventory” AND/OR
• Inventory and Prices tab > disable “Sync pricing with your online store”
  
  

- Feed #2 - file for stock and/or price management

• Mapping tab > choose “Sync inventory levels or pricing” AND
• Mapping tab > choose “Update inventory only” OR “Update inventory and pricing” (if you want to override both stock and prices)
  
  
• Inventory and Prices tab > choose "Sync all inventory updates" AND/OR
• Inventory and Prices tab > enable "Sync pricing with your online store"
  
  

❗️When using a Google sheet to override stock and/or prices, make sure to use sku and qty or retail_price as the column headers. They need to be written like this for Onport to be able to automatically read and identify the content of the columns.

❗️If you're using a Google sheet for product catalog creation, you can either use our template or, if you need to have a custom template, make sure you map the column names to the values in Onport.

🔎 In this article you'll find more information on how to map the values of a Google sheet correctly.