Adding and Updating Products via XML Import / Export Provisioning.

[William Davis]

Is it possible to add and/or update products via XML Import / Export provisioning?

If so, where can I find documentation on how to do same?

[Beefy Nugget]

I think you might be looking for this
https://docs.miva.com/xml/product_add

For Adding Product

 
<Product_Add>


<Code>ale-gallon</Code>


<SKU>sku</SKU>


<Name><![CDATA[Ale, gallon jug]]></Name>


<Price>2.00</Price>


<Cost>1.50</Cost>


<Weight>8.00</Weight>


<Description><![CDATA[A gallon jug of quality ale.]]></Description>


<Taxable>Yes</Taxable>


<Active>Yes</Active>


<CanonicalCategoryCode>food</CanonicalCategoryCode>


<AlternateDisplayPage>PROD</AlternateDisplayPage>


<ThumbnailImage></ThumbnailImage>


<FullSizeImage></FullSizeImage>


<PageTitle>This is my page title</PageTitle>


</Product_Add>

For Updating Product

<Product_Update code="[pCode]"><Code>[pCode]</Code><SKU>[SKU]</SKU></Product_Update>

Interesting enough I cant find the doc for updating on docs.miva. But the tags should be the same as the ones in the product add

[William Davis]

What program can I use to open and edit XML files. I've used Excel in the past, works great, but this time I getting the following error:

"Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: There are multiple root elements. Line 15, position 2.)", same error message with MS XML Notepad 2007.

I don't believe its an editor error, but per a different editor might give me the opportunity to address the error issue.

Any suggestion on editors and/or remedying the problem?

[William Davis]

I was able to export XML file. However, I was not able to open it with any XML editor due to the following error message:

"Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: There are multiple root elements. Line 15, position 2.)"

I opened it with notepad (windows text editor), and below is a copy of “Line 15, position 1 through Line 19, position 30”:

<ProductPaymentRules_Update product_code="103-ME100062">
                <PaymentMethods>
                                <PaymentMethod module_code="" method_code="" />
                </PaymentMethods>
</ProductPaymentRules_Update>

The only thing I noticed is that “ProductPaymentRules_Update” opening and closing tags don’t match.

Is that what is causing the error? What should I do?