To import products from an affiliate website store to our new Opencart (Version 1.5.2.1) Store:
We need an XML feed to be imported straight into our Opencart database
The XML data is for flower products and related gifts.
The following will explain what is needed from the XML
XML Tag -> Opencart value
<fullname> = name
<long description> = description
<Standard_price> = price
The <image> tag from the xml have no definition for main picture and secondary pictures, so we will assume the first <image> row to always be main product picture, and the following 2nd and 3rd <image> rows will be used for the secondary picture column in the following example format
(e.g data/[login to view URL],data/[login to view URL])
<images> -
1st <image> = main image
2nd <image> & 3rd <image> = additional images
Product categories have their unique category id's thus the word Pink will need to be converted to the complimentary category id
(e.g. 46,47,48,61,68,82,84)
<primary_color> = category id
<secondary_color>= category id
<families> = category id
<arrangements> = category id
These are the categories we have created:
category_id | parent_id | name
20 0 By Colour
18 0 Occasion
25 0 By Variety
57 0 By Price
17 0 By Arrangement
24 0 Gifts
33 0 Summer Flowers
34 0 New This Month
82 17 Bouquet
83 17 Cube
84 17 Hand Tied
85 17 Vase
60 20 White
61 20 Blue
62 20 Pink
63 20 Purple
64 20 Red
65 20 Yellow
66 20 Orange
67 20 Mixed
68 25 Roses
69 25 Lilies
70 25 Orchid
71 25 Carnations
72 25 Chrysanthemums
73 25 Freesias
74 25 Gerberas
75 25 Sunflowers
76 25 Plants
77 25 Artificial Flowers
We would also need a page before the database makes any changes and be able to see a list of all the products being imported and have the ability to toggle whether to import certain products or not.