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.

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