Overview
Product import enables retailers to efficiently upload and manage their product catalogs within the Shopthru portal. By importing product data, retailers can ensure their offerings are visible to partners, enabling them to promote up-to-date listings, prices, and availability across channels.
In the Shopthru portal products can be imported either by a CSV upload or a manual process of importing individual product SKUs.
To access these actions navigate to Products > My Products. The import section titled “Add New Products” contains the two choices of import mentioned above and can be found at the top of the page.
CSV Import
The CSV Upload method allows retailers to import product data directly into the portal using a structured spreadsheet file. This is the most straightforward option for bulk uploads and is ideal for retailers who manage their catalog in tools like Excel or Google Sheets.
Clicking on the “CSV Upload” button opens a following form:
- Product Tags - adds “tags”, which will be shown next to all products in the listing that were added in that import. Allows for better grouping and identification.
- Product Set - is a required field that will add all imported products to the one chosen product set, unless it is specified for each product in the CSV file. To learn more about product sets click here.
- File Input - requires a file with a CSV extension.
- Is the first row of your CSV file a header? - allows to specify if the first row in the CSV file is used to add titles to columns. This confirmation helps ensure accurate mapping during the import process.
- Is there a column with the header “sku”? - While column headers in the CSV file are not restricted to specific titles, if the column containing SKU values is explicitly labeled "sku", please indicate "Yes". This confirmation helps ensure accurate mapping during the import process.
Assigning a Product Set
Assigning a product set is a required step during the product import process. You have two options:
- Select a single product set from the form dropdown to apply to all products in the CSV file. Example CSV file content:
sku |
abc123 |
def456 |
- Alternatively, specify a product set name for each product directly within the CSV file using the appropriate product_set column. Please make sure that specified product sets exist within your retailer account, otherwise the import will fail. Example CSV file content:
sku | product_set |
abc123 | Default |
def456 | Electronics |
If product sets are defined in the CSV, they will override the selection made in the form, allowing products to be imported into multiple different product sets as specified.
Manual SKU Import
The Manual SKU Import option allows retailers to add individual products to their catalog by entering SKU information directly into the portal. This method is best suited for small product updates or quick additions when bulk upload is unnecessary.
Clicking on the “Add New SKUs” button opens a following form:
- Product Tags - adds “tags”, which will be shown next to all products in the listing that were added in that import. Allows for better grouping and identification.
- Product Set - is a required field that will add all imported products to the one chosen product set. To learn more about product sets click here.
- SKU Textarea - is a required field that will contain the list of SKUs to upload. They should be comma-separated with no spaces (e.g abc123,TestProductSKU,def456)
Product Import Tools
Retailers using Shopify or Adobe Commerce (Magento) can streamline catalog management by importing ALL products directly from their eCommerce platform. This integration eliminates the need for manual uploads and ensures your product listings remain accurate and up to date.
Navigate to Tools. “Import ALL products from your ecommerce platform” can be found in the Import Tools section.
When you click the "Import ALL products from your eCommerce platform" button, a pop-up window will appear prompting you to select a product set. The selected product set will be applied to all imported products.
To find out how to move already imported products into different product sets in bulk, click here.