Home > User Manual > Tools > Bulk Data Import/Export > Importing & Editing Using CSV

Importing & Editing Using CSV


Step 1. Select from the dropdown menu, 'What do you want to do" and select "I want to upload data to my store". Then choose the data you want to upload. i.e. Brands, Categories, Products, Customers, Pages, Variants, Stock, Subscribers or Redirects.

Step 2. Browse for the Excel Database on your computer and select ok or open. It may take a few minutes depending on your internet connection and the size of your database. Please wait until completed.

A preview of your upload will appear. If you are satisfied, click "Start Import Process"



Step 3. Go to Import / Export History on the left under Tools and click. On the right under the Status column is the processing file. Normally this will read as Queued at an early stage Refresh the page after 5 minutes to check if your import is Completed.

Status of Database Upload


General Database Editing Tips/Rules

  1. Do not change the names of tables or tiles!
  2. Never import any databases successively. i.e. don't upload the same or different databases directly after one another. Some databases control the same data and you will overwrite or duplicate content. Always download a fresh one and work on that.
  3. Do not use formatting for calculations or extra characters in fields such as $ symbol in price, this will cause errors on uploading.
  4. Do not simply copy from other databases into this database, this will often carry odd characters or formatting and will cause errors when uploading. You MUST enter records manually into your spreadsheet or possibly paste into notepad before copying into the database, however, be aware of coding from other websites.
  5. To delete a product, brand, customer or category, please do this from the admin or fill the "delete column available on the spreadsheet. Deleting rows wont delete that file from live database.
  6. When entering a new record, ensure the first column ID's - e.g. productID, categoryID or CustomerID must be blank. Do not enter a made up number.
  7. Visibility options for some columns (Brand, Category and Custom Pages) are as follows;
    Invisible = -2,
    Visible to All = -1,
    Visible only to B2B = 1,
    Visible only to B2C = 0
  8. On spreadsheets, True = Online, False = Offline

Product Database Editing Tips/Rules

  1. Make sure you include the category ID for each product you are uploading, otherwise your product upload will not be seen on your storefront until you go into each one and apply to a category.
  2. To upload a product to multiple categories or brands, use the ; symbol between each category ID, without any spaces under the category ID column. e.g. 42342;424245;65466
  3. If you are updating your product list then reuploading will not duplicate any products. If a product ID is present then it will not be duplicated but if the ID is "Blank" then it will be added as a new product to your store.
  4. The "PicturePath" column title refers to the default of main product image. The "OtherImages" column title referrs to the additional images for each product. Image URL's must be separated by the , punctuation mark. To upload a new image, copy the image URL from the web and paste to the "NewProductImage" column. The system will download the image and place in your store correctly resized.

Customer Database Editing Tips/Rules

  1. When importing the customers database. You must input a customer password or the new customer will not import. Leave the customer ID field empty.

Variant Database Editing Tips/Rules

  1. To import a new variant group with new variants, start by creating a new row. Now enter the ProductID you wish to add this new variant template to. If you don't enter the ProductID, it will only create a new template.
    Enter the VariantGroupTitle but leave the VariantGroupID field empty. Then enter the new variant (VariantTitle) on the same row, leaving the ProductVariantID field empty. This will create a brand new variant group for that product, as well as a new template.
  2. To add a new variant to an existing variant group, make sure the VariantGroupID field is filled. (the VariantGroupTitle should remain empty if it doesn't exist already). Then enter the new variant name (VariantTitle) on the same row, leaving the ProductVariantID field empty.
  3. If you edit the VariantGroupTitle or VariantTitle where they have an existing ID, the system will change the name for that product, as well as creating a new general template. 
  4. The ProductTitle column is for READ ONLY purposes. It is so you can reference which product that this variant is applied to.
  5. If you're uploading your variants for the first time, we recommend creating one template via the admin first. This will help by displaying the correct information on the database download so you can copy and paste down each column. e.g. online status.

Translate and Localize your website with 'Localizer pluggin

Shopping Cart Software by Ashop