grsteffens/zoeyimport

How to format CSV files so they can be imported into Zoey

ZoeyImport

This readme file talks about how to format CSV files so they can be imported into Zoey correctly.

Importing Products

Each CSV file used to import products should have 12 columns, each of which are described below:

1. sku
   • A unique value to identify your product. No two products can share the same SKU.
2. _type
   • This is the type of product, there are 6 different types:
     1. simple
     2. configurable
3. name
   • The name of your product. By default this will also define the URL key and cannot be longer than 60 characters. Name should always be UNIQUE. Having Duplicate Names causes SEO Issues.
4. short_description
   • A short description of your product found by the Add to Cart button.
5. description
   • A detailed description of your product.
6. price
   • The base price of the product, prior to any sales or discounts.
7. status
   • Whether or not to show this product in your store.
     1. enabled = 1
     2. disabled = 2
8. tax_class_id
   • Whether or not to charge tax for this product.
     1. Not Taxable/ None = 1 (couldnt get to work)
     2. Taxable = 2
9. visibility
   • How your customers can find this product.
     1. Not Visible Individually = 1
     2. Catalog Only = 2
     3. Search Only = 3
     4. Catalog and Search = 4
10. weight
    • The weight of your product expressed only as a number.
11. qty
    • Quantity available to purchase
12. is_in_stock
    • If this product is in-stock or not.
      1. 1 = In Stock
      2. 0 = Out of Stock

---

Importing Images

In order to upload a csv file of images, the images must exist on the Zoey server first.They need to be uploaded in yout control panel then you can use the links given to each image to include them in the csv file to associate each with their respective products.

In order to physically upload the image files, login to Zoey. Navigate to the left sidebar menu and go to Advanced > Import & Export. There, navigate to "Image Import" (the 5th row down) and select "Manage". Here, click "Upload Files" in the top right hand corner and select all files desired to be uploaded.

Each CSV file used to import images should have 7 columns, each of which are described below:

1. sku
   • This is a required attribute. Without a SKU the images will not have a place to move to. This SKU must already be in your Products List, either through a CSV Upload or manual creation
2. image
   • This will be your Main Image, the main one that displays on the Products Page.
3. small_image
   • This should be the same value as your Main Image selection.
4. thumbnail
   • This should be the same value as your Main Image selection.
5. _media_image (optional)
   • Use this to assign multiple images to your product to show various views. These will appear as thumbnails on the Products Page
6. _media_position (optional)
   • Use this to assign positions to your additional images. 1 will show first, followed by 2, then 3 and so on.
7. _media_is_disabled (optional)
   • By the default this will be set to not-disabled (0). If you don't want to enable the image you can use this Header and enter 1 as a value.