|
Managing Miva Merchant with Excel |
|
|
|
Page 6 of 6 Importing Your Data via OpenUI Now you need to securely log into your Miva Merchant admin control panel. Once in, look under (click the triangles, not the names) Stores > Store Name > Utilities > Import Data > OpenUI Category Import Then there is an import wizard. Browse your hard drive to find your file to upload, set the delimiter to "Other |" then click next. Once Merchant grabs your file, set the column names as appropriate and then import. And then BAM! Records created or updated in one shot ;-) Next do the same for the products. If this is your first store set-up, you will also need to FTP the category and product images directly into the same folder as you had listed in the image paths in the spreadsheet. This way you can upload all the images at once, as well. I hope this tutorial went a long way to show you how you can easily maintain a store with only Excel, some smart coding and planning.
|