Looking for a fast and efficient way to bring in products from your wholesalers or other systems? CSV file imports make it simple to upload large volumes of inventory all at once, saving time and minimizing manual entry. Read on to learn how to streamline your product intake process with ease.
With CommentSold, retailers can import products between CommentSold accounts and from a wholesaler.
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.
- If uploading multiple images for a single line item, image URLs must be separated by a comma.
- No duplicate products
- No special characters (e.g., quotes, slashes, etc.)
- File headings can be any order. The mandatory headings are Product Name, SKU, Cost, Retail Price. Other headings you can include are outlined in the below drop-down:
| Heading Name | Required? | Notes |
| Product Name | Yes | |
| Product Description | ||
| Mobile Description Enabled | This column must have a 1 (Enabled) or 0 (Disabled) for each product. | |
| Mobile 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 Badge | ||
| Final Sale | ||
| Product Received | This column must have a 1 ("Is received") or 0 ("Is not received") for each product. | |
| Product Shipping Cost | ||
| Product Low Stock Limit | ||
| Product Split By Type | ||
| Product Options | ||
| Product Addons | ||
| Product Hide On Waitlist | ||
| Product Best Selling | This column must have a 1 ("Is a Best Seller") or 0 ("Is not a Best Seller") for each product. | |
| Collection | ||
| App notification Title | ||
| App Notification Body | ||
| Product Notes | ||
| Product Images | ||
| Variant Received | ||
| Variant Archived | ||
| Fulfilment Notes | ||
| Product Categories | ||
| Product Attribute 1 Label | ||
| Product Attribute 2 Label | ||
| Product Attribute 3 Label | ||
| Product Tags | ||
| Warehouse | ||
| External Product Type | ||
| Inventory Quantity | ||
| 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 Stock Low Notifications | ||
| Inventory Stock Low | ||
| Inventory Attribute 1 | ||
| Inventory Attribute 2 | ||
| Inventory Attribute 3 |
Step 1: Create your CSV File
- Download the CSV Template – You can download our import template here. The file will automatically download to your device.
- Fill in the highlighted fields – Additional info can be added as needed. Check out our [demo here] for guidance on adding multiple variants per SKU.
- Once complete, save the file in a CSV format.
Step 2: Import your CSV File
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 from the Import drop-down 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.
Note: When importing...
- 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.
Troubleshooting Errors
|
Having trouble importing products with a CSV? Here are some common issues and resolutions. Issue: Images are not uploading when importing products via CSV
Issue: Some or all items in the CSV are showing as failed
Issue: Uploading multiple images for a single product
Error: “Invalid CSV Format”
Error: “Invalid data / Duplicate SKU or variant”
Error: “Unknown Error”
Issue: CSV upload spins, times out, or shows complete but products don’t appear
If this happens, rename the CSV file completely and upload again. |