How to override vendor's stock/prices or curate their product catalog

Filipa
Filipa
  • Updated

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 > selectSync inventory levels or pricingAND
  • Mapping tab > select "Update inventory only" OR "Update inventory and pricing"
    Image 10-2-2023 at 4.30 PM.jpg
  • 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)

Image 10-2-2023 at 4.32 PM.jpg

- Feed #2 - file for product catalog creation

  • Mapping tab > choose “Publish items to my online storeAND
  • Mapping tab > choose “Product data for publishing
    Image 10-2-2023 at 4.33 PM.jpg
  • Inventory and Prices tab > choose “Don’t sync inventoryAND/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)
    Image 10-2-2023 at 4.34 PM.jpg

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 storeAND
  • Mapping tab > choose “Product data for publishing
    Image 10-2-2023 at 4.33 PM (1).jpg
  • Inventory and Prices tab > choose “Don’t sync inventoryAND/OR
  • Inventory and Prices tab > disable “Sync pricing with your online store
    Image 10-2-2023 at 4.34 PM (1).jpg

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

  • Mapping tab > choose “Sync inventory levels or pricingAND
  • Mapping tab > choose “Update inventory onlyORUpdate inventory and pricing” (if you want to override both stock and prices)
    Image 10-2-2023 at 4.30 PM (1).jpg
  • Inventory and Prices tab > choose "Sync all inventory updates" AND/OR
  • Inventory and Prices tab > enable "Sync pricing with your online store"
    Image 10-2-2023 at 4.32 PM (1).jpg

❗️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.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.