Web Hosting Services by Total Hosting. One Click Joomla, WordPress, Blog, CMS, Portal installs Free! The best web hosting provider.

Toll-Free: 888.600.5630
Home arrow Hosting Articles arrow Managing Miva Merchant with Excel
Managing Miva Merchant with Excel Print E-mail
Article Index
Managing Miva Merchant with Excel
What is an eCommerce site, really?
Setting Up Categories
Setting Up Products
Working With Spreadsheets
Importing Your Data via OpenUI

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.



 
< Prev   Next >

Client Entry

Email Address:
Password:

Support

Pre-Sales Questions? Website Issues? We have you covered 24x7:
Online Support Desk
Telephone: 888-600-5630

Start Now

All set? Then
Sign Up for Hosting Now

Affiliate $

Join our affiliate program and start earning money today.