Click on any of the images or GIFs in this article for a closer look.

  In this article, you'll learn:

  • How to import products to CommentSold using a CSV file.
  • How to export products from CommentSold to a CSV file.
  • How to export an entire product collection to a CSV file.

About Importing and Exporting Products

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

  • File headings must follow the below order:

    • Product Name
    • Product SKU/Style #
    • Product Best Selling
      • This column must have a 1 ("Is a Best Seller) or 0 ("Is not a Best Seller") for each product.
    • Inventory Quantity
    • Inventory Cost
  • No product duplicates
  • No commas

How Importing and Exporting Products Benefits Your Business

  • Quickly add products you receive from your wholesalers to your inventory for a faster product intake process.
  • Easily add new products you select from wholesalers while at market events for interactive, on-the-spot market live sales.

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.

  1. Select Products in the side menu of your CommentSold dashboard.
  2. Select Import Product CSV in the top-right corner of the page.
  3. In the pop-up, select Choose File.
  4. Locate and select the CSV file you wish to import.
  5. 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. 
  6. 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.
  7. 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.

Export Products

You have two options when exporting products from CommentSold: export individual products in bulk and export an entire collection.

Export Individual Products in Bulk Export an Entire Collection

  1. Select Products in the side menu of your CommentSold dashboard.
  2. 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.
  3. Select the checkbox to the right of each item you wish to export.
  4. At the top of the product listing, select the green Selected drop-down.
  5. 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.
  6. Select Export.

If you wish to view exported files, select View Exported Files in the top-right corner of the page.

Learn More

  • Inventory Management

Share this article

Subscribe on YouTube
Was this article helpful?
3 out of 3 found this helpful

We're here to help

Reach out to our support team, connect with our community, or ask an expert.