Project Detail

Description

Create product categories, attributes and import items and their attribute into Magento Database.

The database is in XML format or CSV format.

The XML elements for a given product may include some or all of the following:
<PRODUCTS>
<PRODUCTS_NAME></PRODUCTS_NAME>
<PRODUCTS_DESCRIPTION></PRODUCTS_DESCRIPTION>
<PRODUCTS_IMAGE></PRODUCTS_IMAGE>
<PRODUCTS_PRICE></PRODUCTS_PRICE>
<ITEM_UPC></ITEM_UPC>
<ITEM_HEIGHT></ITEM_HEIGHT>
<ITEM_LENGTH></ITEM_LENGTH>
<ITEM_DIAMETER></ITEM_DIAMETER>
<PRODUCTS_WEIGHT></PRODUCTS_WEIGHT>
<MANUFACTURERS_NAME></MANUFACTURERS_NAME>
<PRODUCTS_MODEL></PRODUCTS_MODEL>
<PRODUCTS_QUANTITY></PRODUCTS_QUANTITY>
<PROP_COLOR></PROP_COLOR>
<PROP_PACKAGING></PROP_PACKAGING>
<PROP_MATERIAL></PROP_MATERIAL>
<PROP_TEXTURE></PROP_TEXTURE>
<PROP_FRAGRANCE></PROP_FRAGRANCE>
<PROP_FLAVOR></PROP_FLAVOR>
<PROP_HERBAL></PROP_HERBAL>
<PROP_SIZE></PROP_SIZE>
<PROP_OUNCES></PROP_OUNCES>
<PROP_CELEB></PROP_CELEB>
<PROP_FUNCTION_1></PROP_FUNCTION_1>
<PROP_FUNCTION_2></PROP_FUNCTION_2>
<PROP_FUNCTION_3></PROP_FUNCTION_3>
<PRODUCTS_TYPE></PRODUCTS_TYPE>
<PRODUCTS_TYPE></PRODUCTS_TYPE>
<PRODUCTS_TYPE></PRODUCTS_TYPE>
<PRODUCTS_QUICKSEARCH></PRODUCTS_QUICKSEARCH>
<PRODUCTS_QUICKSEARCH></PRODUCTS_QUICKSEARCH>
<PRODUCTS>

Some notes on some of the less obvious XML fields:

The <ITEM_HEIGHT> will often contain three values separated by ‘X’ – for example 4X2X3 – this represents the products full dimensions in inches.
The <DISCOUNT_ZERO> field denotes a product that is not discountable (even if it is a closeout).
The <PROP_FUNCTION_> field denotes up to 3 different extra product characteristics such as ‘Edible’ or ‘Sugar Free’.
The <PRODUCTS_TYPE> is the category name to which the product belongs. For example – ‘Holiday’ or ‘Costume’. Products may belong to up to 3 categories.
<PRODUCTS_QUICKSEARCH> is a secondary category classification to which the product may or may not belong. For example – ‘For Her’ or ‘Birthday’. There are 20 Quick Search categories – some products will not belong to any while some will belong to several.

NOTE: In order to keep the XML file as lean as possible, if there is no data for a node, the node doesn’t appear. For example, if the quantity is zero there would be no <PRODUCTS_QUANTITY> node; another example would be if there is no <PROP_PACKAGING> specified, that node would not appear


Additional files submitted:
sampleproducts.xml