Product Import

Modified on Mon, 18 Dec, 2023 at 9:45 AM

Overview

   You may import or update products through a comma-separated (CSV) file. To get started, download the sample import file from the import Products section by doing the following:

  1. Log in to the Back Office/Manager part of Cloud Retailer
  2. Click on "Tools"
  3. Click on "Import Tools"
  4. Scroll down and click on "Products"
  5. (if needed) - click on "here" where it says "Click here for a sample import file for reference"


Procedure


Exercise caution:
If you do not specify a location within the file, you must select a location from the drop-down. 
If you fail to do so, your file will override the values for all locations.


NOTE:  For all Price entries, DO NOT put in the dollar sign - $  It is not needed and can cause issues.


The file can contain the following columns. A *indicates the column is required.
  • Code *
         This is the product's UPC or part number.  One must be provided for the product to be imported.
  • Description
  • Notes
  • Department
         This will check to see if the department exists by checking this against the department's code.  If it cannot find a match it will create a new department setting the description and code to be equal to this value.  The same holds true for many other values like categories, suppliers, etc.  If you would like more control over this use the specific functions to import departments, categories, suppliers, etc.
  • Category
  • Classification
         This is known as the Sub-Category.
  • Size
    PriceLowerBounds
  •      The lowest acceptable sold price.
  • PriceUpperBounds
         The highest acceptable sold price.
  • Cost
         You can create cost adjustments by reimporting the same product at a different cost.
  • RegularPrice
  • PriceA
  • PriceB
  • PriceC
  • TagAlongItem
         A barcode of a product to tag along.
  • TagAlongQuantity
         Enter how many tag-along products to include.
  • SalePrice
         The sale price.
  • SaleStartDate
         The date and time when the sale starts.
  • SaleEndDate
         The date and time when the sale ends.
  • Type
    • Standard
    • Voucher/Gift card
    • Non-Inventory
    • Not Contributing To Sales
  • Tax
         Populate with your Tax Description found under Admin > Sales Taxes.
  • IsActive
         (A true or false column.)
  • AlternateCode:1:Type
    • Other
           A unique barcode that is shared with one other product (alternate lookup code).
    • Bar code
           A unique barcode that must follow GS1 General Specifications and is shared with one other product (alternate lookup code).
    • Repeating
           A unique barcode that is shared amongst many other products.
          You scan the repeating barcode and it will return all the products in which it is shared with. Popular with vintages.
  • AlternateCode:1
         Enter an alternate product code used for this product.
  • AlternateCode:2:Type
         Repeat as needed.
  • AlternateCode:2
         Repeat as needed.
  • Supplier
         Populated with a supplier name.
  • ReorderNumber
         Populated with a supplier unique reorder number
  • LeadTime
         Populated with the number of days lead time.
  • CaseQuantity
         Populated with how many are in a case.
  • Attribute.Additional Product Data.MSRP
         You can use Attributes to create custom fields for use on products.
         The example above is an "Additional Product Data" section with an MSRP field.
  • Attribute.Additional Product Data.Weight
         You can use Attributes to create custom fields for use on products.
         The example above is an "Additional Product Data" section with a Weight field.
  • ProductTag:1
         The value can be a short single-word description example: EBT or Weighted.
  • ProductTag:2
         Repeat as above.
  • MinQuantity
         Minimum quantity to keep on hand.
  • MaxQuantity
         Maximum quantity to order.
  • IsAvailable
         A true or false column. Should this product be available for the designated location.
  • Settings:IsMagentoWebsiteEnabled
         A true or false column. Should this product be listed in Magneto.
  • Location
         Define which location to add or update. This can be one location per line, or semi-colon-separated. example: Location1;Location2
  • IsPrimary
         A true or false column. Designates the associated supplier should be the primary supplier.
  • Settings:PromptForQuantity
        A true or false column. Should the product prompt for quantity at the Point-of-Sale.
  • PromptForPrice
        A true or false column. Should the product prompt for price at the Point-of-Sale. 
  • NotDiscountableAtPos
        A true or false column. Should the product allow discounts at the Point-of-Sale. - NOTE: This can be overridden by a discount that specifies it, or a Task Pad Button.
  • Settings:IsSearchable
        A true or false column. Should the product be searchable at the Point-of-Sale.


All of our Import files generally follow RFC 4180. However, our import libraries include some advanced features beyond strict RFC 4180 compliance. One of these features is that we allow for comment lines in our import files - any line prefixed with a # will be considered a comment and ignored by the Import tools. This includes, for example, the Product Code field. If you notice any files where items do not import, please ensure that your first column in the CSV file doesn't start with a number sign (#).


Here is a video showing the process to download the sample file:



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article