BuyItSellIt Community
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Using the XML Bulk Upload with Excel Expand / Collapse
Author
Message
Posted 12/5/2008 9:42:08 AM


BISI Admin

BISI Admin

Group: Administrators
Last Login: Today @ 6:15:51 PM
Posts: 2,976, Visits: 8,606
You can easily edit the XML doc using Excel but this method does not support variants. (Since Excel can't edit child nodes).

You'll need to remove anything that is in the entire <variants> node. I've attached an XML doc with no additional variants that you can use as a reference.

When opening an XML doc in excel, It will prompt you with the following:


Choose the "As an XML table" option.

This will load the document so you can edit your data just like you did in the spreadsheet method. When saving your product, you'll need to use the "Save As" and choose the XML Data option. (Not XML Spreadsheet!).

---------------------
Tomas

Follow BISI on twitter!

  Post Attachments 
bulkupload_withnovariants.xml (1,800 views, 16.11 KB)
bulkupload_withnovariants_multipic.txt (525 views, 17.40 KB)
Post #22382
« Prev Topic | Next Topic »


All times are GMT -8:00, Time now is 6:25pm

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 7.313. 11 queries. Compression Disabled.