Bulk Upload of Product Templates

A forum where issues related to the DataPort utility can be discussed.
Post Reply
hypnotoad
Ensign (ENS)
Ensign (ENS)
Posts: 2
Joined: Sun Jul 11, 2010 11:07 am

Bulk Upload of Product Templates

Post by hypnotoad » Tue Oct 05, 2010 7:58 am

I have been trying to bulk upload product templates for days now and cannot seem to get it. My xml file matches that of the one I exported. Ids all match up, but they aren't updating... any ideas?

Here is my xml:

<AbleCommerceExport>
<Store>
<Products>
<Product>
<ProductId>29819</ProductId>
<StoreId>1</StoreId>
<Price>280</Price>
<MSRP>350</MSRP>
<Sku>10069</Sku>
<ModelNumber>0101-0035C</ModelNumber>
<TaxCode>Taxable</TaxCode>
<Shippable>1</Shippable>
<WarehouseId>1</WarehouseId>
<Warehouse>Truck Gear Network</Warehouse>
<ProductTemplateId>0</ProductTemplateId>
<TemplateFields>
<ProductTemplateField>
<ProductId>29819</ProductId>
<InputFieldId>22</InputFieldId>
<InputValue>$50 - $100</InputValue>
</ProductTemplateField>
</TemplateFields>
<ProductProductTemplates>
<ProductProductTemplate />
<ProductId>29819</ProductId>
<ProductTemplateId>6</ProductTemplateId>
</ProductProductTemplates>
</Product>
</Products>
</Store
</AbleCommerceExport>

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: Bulk Upload of Product Templates

Post by Naveed » Wed Oct 06, 2010 9:27 am

The XML structure seems correct, however missing some information like product name and category. You can find such products without category information at:

"Administration > Catalog > Orphaned Items"

But closely looking at your provided xml I identified one issue, look at the following:
<ProductProductTemplates>
<ProductProductTemplate />
<ProductId>29819</ProductId>
<ProductTemplateId>6</ProductTemplateId>
</ProductProductTemplates>
You specifying "<ProductProductTemplate />" , which is a empty closing tag, the above part of the XML should be something like:

Code: Select all

<ProductProductTemplates>
    <ProductProductTemplate>
        <ProductId>29819</ProductId>
        <ProductTemplateId>6</ProductTemplateId>
    </ProductProductTemplate>
</ProductProductTemplates>
Also make sure that the respective ProductTemplate exists and having exact same fields.

Post Reply