Want a quick and easy way to upload products from your wholesalers and/or streamline your intake process? Read on to learn more.
Importing and exporting products using a CSV file is an easy way for retailers to copy a large number of inventory items from one system to another.
With CommentSold, retailers can import products between CommentSold accounts and from a wholesaler. You can download our import template here. The file will automatically download to your device.
When importing products, the CSV file must meet the following requirements or the import will fail:
-
Images must be hosted by a publicly accessible URL. Ensure the URL is correct and CommentSold will read the image file in the upload.
- No duplicate products
- No special characters (e.g., apostrophes, quotes, commas, slashes, etc.)
-
File headings must follow the order outlined in the below drop-down:
| Heading Name | Required? | Notes |
| Product Name | Yes | |
| Product Description | ||
| Product App Description | ||
| Product Store Description | ||
| Product SKU/Style # | Yes | |
| Product Brand | ||
| Product Brand Style # | ||
| Product Charge Tax | This column must have a 1 ("Charge taxes) or 0 ("Do not charge taxes") for each product. | |
| Product Tax Code | ||
| Product Type | ||
| Product Received | This column must have a 1 ("Is received") or 0 ("Is not received") for each product. | |
| Product Shipping Price | ||
| Product Low Stock Limit | ||
| Product Split By Type | ||
| Product Options | ||
| Product Addons | ||
| Product Hide On Waitlist | ||
| Product Best Selling | Yes | This column must have a 1 ("Is a Best Seller") or 0 ("Is not a Best Seller") for each product. |
| Product Notes | ||
| Product Images | ||
| Product Categories | ||
| Product Attribute 1 Label | ||
| Product Attribute 2 Label | ||
| Product Attribute 3 Label | ||
| Product Tags | ||
| External Product Type | ||
| Inventory Quantity | Yes | |
| Inventory Color | ||
| Inventory Size | ||
| Inventory Weight | ||
| Inventory Retail Price | Yes | |
| Inventory Sale Price | ||
| Inventory Cost | Yes | |
| Inventory Barcode | ||
| Inventory SKU | ||
| Inventory Length | ||
| Inventory Width | ||
| Inventory Height | ||
| Inventory Position | ||
| Inventory Notes | ||
| Inventory Images | ||
| Inventory Location | ||
| Inventory Attribute 1 | ||
| Inventory Attribute 2 | ||
| Inventory Attribute 3 |
Import Products
If you have a CSV file that contains products from a wholesaler or even another CommentSold account, you can easily import that file—and those products—into your CommentSold account.
- Select Products in the side menu of your CommentSold dashboard.
- Select Import Product CSV in the top-right corner of the page.
- In the pop-up, select Choose File.
- Locate and select the CSV file you wish to import.
- Select the action you wish for CommentSold to take if there are duplicate SKUs in the CSV file you're importing into your CommentSold Account:
- Error - No data will be imported at all if there are any duplicates. CommentSold will not import any of the products included in the CSV file.
- Prefix - A new product will be created with a random prefix in the SKU. CommentSold will attach a random prefix to the SKU of imported products. These prefixes will be identical, allowing you to search for the imported products and enter your own unique SKUs for each item's Products page.
- Ignore - This product row and associated variants will be skipped. CommentSold will import every product except duplicate SKUs.
- Overwrite - The existing products and variants will be updated. The imported information will replace existing product information in CommentSold.
- Select your desired Margin %.
- CommentSold will use the Inventory Cost provided in the CSV file to calculate the Retail Price necessary for the margin percentage.
- For example, if a product has a cost of $10 and a margin of 50% is set, CommentSold will set the retail price to $20.
- Select Import to start importing process.
- If a margin percentage is not entered, CommentSold will use the price in the CSV file’s Inventory Retail Price column for an imported product’s retail price.
- Inventory quantities will reflect the wholesaler's inventory amounts. If you want to offer less than the total wholesale amount, you will need to change the inventory amounts for each product.
You can check the progress of your import using the progress bar on this page or select View Import Progress in the top-right corner of the Products page.
After the import process is complete, you'll need to resolve any warnings listed beneath the number of successfully imported rows. Once resolved, you can confirm that all rows have been imported.
Export Products
You have two options when exporting products from CommentSold: export individual products in bulk and export an entire collection.
- Select Products in the side menu of your CommentSold dashboard.
- Adjust the number of items shown on a page using the Show Entries drop-down at the top of the product listing. This allows you to view all the products you wish to export on one page.
- Select the checkbox to the right of each item you wish to export.
- At the top of the product listing, select the green Selected drop-down.
- Select Export Products to CSV, then select your preferences:
- For Cost. Choose Use Product Cost or Use Product Price. If you are a wholesaler exporting products for a shop, you may want to select product price.
- For Quantity. Choose Use Quantity or Skip this Field. If you want to show the quantities you have in stock on the CSV file, choose Use Quantity.
- Select Export.
- Select Products in the side menu of your CommentSold dashboard.
- Select Filters at the top of the product listing.
- In the pop-up, select In Collection.
- Locate the Collections drop-down, select the collection(s) you wish to export in the Collections dropdown, then select Apply.
- Adjust the number of items shown on a page using the Show Entries drop-down at the top of the product listing. This allows you to view all the products you wish to export on one page. Only products on the current page will be exported.
- At the top of the product listing, select the Select All checkbox, then select the green Selected drop-down.
- Select Export Products to CSV, then select your preferences:
- For Cost. Choose Use Product Cost or Use Product Price. If you are a wholesaler exporting products for a shop, you may want to select product price.
- For Quantity. Choose Use Quantity or Skip this Field. If you want to show the quantities you have in stock on the CSV file, choose Use Quantity.
If you wish to view exported files, select View Exported Files in the top-right corner of the page.
Learn More
- Add New Products in CommentSold. Learn how to create and add new products to your shop’s inventory.
- Create Product Templates. Learn how to create pre-filled templates for fast product creation.
- Manage Product Visibility. Learn how to manage which products are available for your shoppers to purchase.