We Speak OpenUI


Frequently Asked Questions:
StoreMan/Server Interaction

Questions and answers about your server and using StoreMan.

If you don't find your answer here, please contact us.


1. How do I get my data files from my server?
2. What files do I need to get?
3. How do I find my Server Path to set up FTP in StoreMan?
4. What does the StoreMan Update utility do?
5. I added many products in StoreMan. I uploaded them to my server, but why don't I see them?
6. I'm getting an error message when I use the FTP utility. What's wrong?
7. When I use FTP with a large file (like products.dbf), why does it look like StoreMan freezes?
8. When I run the StoreMan Utility on my server for the first, it tells me I have no backup files. Should I worry?
9. I uploaded new files from StoreMan, and update my server, but now I need my old information back. Can I do this?
10. I have a Miva Mia 'mirror' of my site. I have linked to the files in the mirror, but when I make changes, they are not showing up. What's wrong?
11. I did the FTP upload of my files from within StoreMan. Why don't I see my changes?
12. Can I FTP my own files?


1. How do I get my data files from my server? - Top

You will need to use an FTP program to download your product database files to your local machine so that StoreMan can use them. Once you have them on your local machine, you can use the internal FTP within StoreMan to upload and download.

Merchant installations can vary widely, but most installations store Merchant data within a directory called HTSDATA, or MIVADATA. There will be a Merchant2 directory, and within that is your store directory (typically 0000000N where N is the number of your store). The store directory is where you need to get most of your data files.

In addition to the product-oriented files, there are also some Look and Feel-oriented files you will need to transfer. These will be either in the MMUI or OUI directories in the 0000000N store directory.


2. What files do I need to get? - Top

For Merchant 3.x: agpxcat.dbf, agpxprod.dbf, attr.dbf, attr.dbt, cats.dbf, catxprod.dbf, opts.dbf, opts.dbt, pgpxprod.dbf, products.dbf, products.dbt, relprod.dbf, upsell.dbf, upslprod.dbf, *mmuicats.dbf, *mmuicats.dbt, *mmuiprds.dbf, *mmuiprds.dbt, *prodlayo.dbf

* these files are located in /MMUI directory. If you are using OpenUI, substitute "oui" for "mmui" above.

For Merchant 4.x: agpxcat.dbf, agpxprod.dbf, attr.dbf, attr.dbt, cats.dbf, catxprod.dbf, inv_cnt.dbf, inv_prd.dbf, inv_prd.dbt, opts.dbf, opts.dbt, pgpxprod.dbf, products.dbf, products.dbt, relprod.dbf, upsell.dbf, upslprod.dbf, *mmuicats.dbf, *mmuicats.dbt, *mmuiprds.dbf, *mmuiprds.dbt, *prodlayo.dbf

* these files are located in /MMUI directory. If you are using OpenUI, substitute "oui" for "mmui" above.


3. How do I find my Server Path to set up FTP in StoreMan? - Top

This has many answers, depending on Operating System, whether you have a shared, virtual or dedicated server, and how Merchant was set up on your server.

In general, your store directory will reside within a Merchant2 directory, which in turn resides within a Mivadata or Htsdata directory. You need to find the path from the root (bottom level of directories that you log in to with FTP) to your store. An example would be:

/usr/local/etc/httpd/htsdata/Merchant2/00000002/

Your own server path will likely be somewhat different. It will contain the last two directories.


4. What does the StoreMan Update utility do? - Top

The StoreMan Update utility provides a few vital features.

First, it makes a backup of your existing product database files, so that if anything happens while updating your store, you have a known good set of files to restore.

Second, it swaps in product database files you have uploaded from StoreMan.

Third, it adjusts your storekey.dbf file to update product, category, attribute and option entries.

Fourth, it packs your store so that all the changes you have made become active in your store.


5. I added many products in StoreMan. I uploaded them to my server, but why don't I see them? - Top

Most likely you forgot to run the StoreMan Update Utility from your Merchant Administration screen. StoreMan uploads database files with a *.new extension in addition to the normal file extension. This is done to minimize downtime in your store. The Update Utility renames these files (among other things).


6. I'm getting an error message when I use the FTP utility. What's wrong? - Top

First, make sure the FTP Site, Username, and Password are entered correctly in the FTP Setup window (StoreMan) or the Profile (StoreMan Pro). One wrong or missing character, even uppercase when it should be lowercase, will cause the FTP operation to fail.

Second, make sure that the Server Path 1 is correct. It needs to start and end with a '/' character. This accounts for a lot of support issues when first setting up StoreMan.

Third, make sure you are online (hey, it can happen to anyone).


7. When I use FTP with a large file (like products.dbf), why does it look like StoreMan freezes? - Top

This is due to the way we wrote the FTP code. It 'goes away' while it is transferring, and the screen may go partially blank. The behavior is most pronounced with large files that take many minutes to transfer.

The good news is, it's not broken and it's not freezing. It's just (for now) and unavoidable byproduct of the code. We recommend you take a break while the files are transferring. (Don't you need a break anyway?)


8. When I run the StoreMan Utility on my server for the first, it tells me I have no backup files. Should I worry? - Top

No, this is as it should be. StoreMan Utility makes a backup of your existing store files before it does an Update with your new information. The first time, there are no backup files yet. After you Update, there will always be backup files (unless you delete them).


9. I uploaded new files from StoreMan, and update my server, but now I need my old information back. Can I do this? - Top

Yes! StoreMan Utility makes a backup of your files every time you Update. You can open the utility and select Restore Old Content, and it will restore the last backup.


10. I have a Miva Mia 'mirror' of my site. I have linked to the files in the mirror, but when I make changes, they are not showing up. What's wrong? - Top

When working with a Miva Mia local site where you are linking to the same files in StoreMan, you need to do a Pack from within the local Merchant Admin before you see any changes made with StoreMan.


11. I did the FTP upload of my files from within StoreMan. Why don't I see my changes? - Top

Uploading is the first step, and the second is to run the StoreMan Utility installed into your Merchant store.

StoreMan uploads all database files with an extension of .NEW (so they don't overwrite your existing store files). The StoreMan Utility backs up your existing files, renames the *.NEW files to their original names, and Packs your store.


12. Can I FTP my own files? - Top

We do not recommend it, but if you find it necessary, here is what you should do:

Rename all the files that StoreMan uses and add a .NEW extension to all of them.

Upload to your server.

Use the StoreMan Utility to backup, update and pack your store data files.