I have a supplier who now lists all products in a XML file held on there server, I want a script that can check and update every 2-3 hours or so and then do a full update of products in CubeCart v4.
The XML file is stored on there website but for some reason is in a zip file, so will need to be extracted aswell.
The feed has approximately 3000 products
Script needs to be able to create the categories aswell and any sub categories that the files needs aswell as products, main reason for this is to cut down on administrative tasks like updating stock levels and pricing + adding new products.
## Deliverables
Example format, lines in BOLD are the ones needed to be imported into the products backend, also some parts need to be altered on import, need the ability to add percentage to the pricing and to add .jpg to the imagecd line as i have all images uploaded already.
<Product_List>
<Item>
**<Category>Alarms</Category>**
**<SubCategory1>Accessories</SubCategory>**
**<SubSubCategory 2/>**
<PartNum>AN-01A</PartNum>
** <ProductNameS>AN-01A</ProductNameS>
<ProductName>Jablotron AN-01A External antenna for JA-63, JA-65, JA-60F and JA-60A</ProductName>
<ProductDescription>Jablotron AN-01A External antenna for JA-60, working frequency 433.9 MHz, impedance 50, 2m total length, 0.34m active part length</ProductDescription>**
<Qty1>1</Qty1>
<PriceEx1>8.85</PriceEx1>
**<PriceInc1>9.73</PriceInc1>**
<Qty2>5</Qty2>
<PriceEx2>8.65</PriceEx2>
<PriceInc2>9.51</PriceInc2>
<Qty3>10</Qty3>
<PriceEx3>8.45</PriceEx3>
<PriceInc3>9.29</PriceInc3>
**<Unit>Item</Unit>**
<BoxHeight>20</BoxHeight>
<BoxWidth>85</BoxWidth>
<BoxLength>130</BoxLength>
<BoxVolume>0.000221</BoxVolume>
**<Weight>0.05</Weight>**
**<WarrantyDS>1-year RTB</WarrantyDS>**
<VendorURL />
<Vendor>Jablotron</Vendor>
**<PriceRRP>49.00</PriceRRP>**
**<Stock>N</Stock>**
<StockShow>1</StockShow>
**<ImageCD>3145</ImageCD>**
**<ProductID>6402</ProductID>**
<ETADate />
</Item>
This needs to be compiled in a way that it is easy to reinstall, i am quite IT literate and need instructions given on how to do this, i would like it embedded into the cubecart backend section.
I need this done as soon as possible and appreciate your time for looking at my job request.