|
Managing Miva Merchant with Excel |
|
|
|
Page 4 of 6 Setting Up Products
For your Product spreadsheet, you need the following Column Headings:
CAT_CODE - The final category code from the previous spreadsheet
CODE - The Product's Unique SKU or Code
NAME - The name that is displayed
THUMBNAIL - The path to the thumbnail image for your product
IMAGE - The full sized image
PRICE - The selling price
COST - The cost of the product (useful when offering distributor pricing, XX% over cost)
DESC - The product's description
WEIGHT - The unit weight. Needed to calculate anything but flat rate shipping
TAXABLE - Is this item taxable? Value = TRUE/FALSE
ACTIVE - Is this product currently live? Value = TRUE/FALSE
HEADER - Can give a product a unique header
FOOTER - As well as footer
The same rules apply to products, when it comes to building naming conventions and descriptions and headers. Use formulas combined with HTML templates to automate the process as much as possible. It is also useful when naming images to use the product code as a root in your image name: prodcode.jpg, prodcode_th.jpg, etc. This way you can do more with your pages. This will be covered in the future.
You should now have a full spreadsheet for your CategorySubcategories and one for your Products.
|
Hosting Articles 