Introduction
In this article, we describe how to publish products and sync product details from vendors using Shopify's CSV format.
Getting started
Onport can directly integrate with your vendor's store, allowing you to publish items without having to spend hours copying product details. If your vendor is using a custom system or isn't on one of our support platforms, they can also use a CSV import to sync inventory, pricing, or even publish products.
To achieve that please follow these steps:
-
Create a new CSV feed for the new vendor settings > Contacts > Product tab > "New inventory feed".
-
You will be redirected to the Inventory > Inventory feed and need to select the option "FTP & HTTP(s) CSV".
-
Add the feed URL.
Onport fully supports password-protected resources, according to the RFC 1738 specifications.
Here are some examples of the supported URL protocols:http://username:password@host/path/to/file.csv https://username:password@host/path/to/file.csv ftp://username:password@host/path/to/file.csv ftps://username:password@host/path/to/file.csv
4. Before fetching the feed, you'll need to map the column names to the columns in Onport, under the Mapping tab - SKUs and quantity must match. Just add a new custom mapping, and map your header names for Sku and Inventory quantity appropriately. If you are using Shopify's CSV format, you'll see a button to access an example template if you are just getting started.
- When mapping values, you need to have at least the Name, qty, and SKU. Mapping is case-sensitive, which means slight differences in capitalization may make it so the feed doesn't fetch.
5. Once this is done, you can fetch the feed. Imports are processed in a queue in Onport and it may take a few minutes for the feed to be imported. If you are importing several thousand items, it may take longer. You'll be notified via email once the import has been completed.
Feed fetching
These feeds will fetch daily, under normal circumstances. If whatever party is responsible for updating the file can't do it frequently enough, the quantities sold may result in discrepancies when the feed fetches again if those sales have not been accounted for in the file. If between you and your vendor you realise that may be the case, it may be better to have the feed fetching manually only, in which case you should reach out to our Success team.
Comments
0 comments
Please sign in to leave a comment.