Backup and Restore
The "Backup / Restore" section of eShox can be accessed via eShox Admin. Open a Web browser and enter the following URL: http://your-domain-or-ip/shop/admin/. Click on "Backup / Restore" under "Database Management" on the left "Administration" window.
eShox includes the ability to backup the entire database, including preferences and order data, and restore the data at a later date. To create a backup, click "Backup" and a .sql file will be generated with all of the database information. To restore, choose the backup file from which to restore and click "Restore". Warning: All store data and preferences will be restored by the restore function.
Importing and exporting store data
The "Import/Export" section of eShox can be accessed via eShox Admin. Open a Web browser and enter the following URL: http://your-domain-or-ip/shop/admin/. Click on "Import/Export" under "Database Management" on the left "Administration" window. Import/export options include:
Orders
The "Orders" options are used to export order data to XML or to a tab-delimited text file. The XML format is useful when importing order data into FileMaker or other solutions. The TXT format is more customizable via a set of [tags] that define how the exported file should look. The TXT [tags] include:
[address]
[affiliate]
[bill_address]
[cc_expires]
[cc_number]
[cc_owner]
[comments]
[currency]
[currency_value]
[customer_address2]
[customer_address]
[customer_city]
[customer_company]
[customer_country]
[customer_name]
[customer_postcode]
[customer_state]
[date]
[delivery_address2]
[delivery_address]
[delivery_city]
[delivery_company]
[delivery_country]
[delivery_name]
[delivery_postcode]
[delivery_state]
[email]
[logo]
[order_id]
[page_title]
[payment_method]
[phone]
[product]
[option]
[option_name]
[option_value]
[option_price]
[/option]
[product_cost]
[product_id]
[product_image]
[product_model]
[product_name]
[product_price_extax]
[product_price_intax]
[product_sku]
[product_tax]
[product_total_extax]
[product_total_intax]
[qty]
[serial_number]
[/product]
[ship_address]
[shipping]
[status]
[stylesheet]
[subtotal]
[tax]
[total]
The [product] and [option] tags are repeated for each product and it's product/customer options.
Customers
The "Customers" option is used to import/export customer data from/to a tab-delimited text file. New customers imported should have a blank customer ID field; eShox will assign an ID upon import. Customers imported that already exist will be matched by their customer ID and updated with the imported data.
To import customers, choose a file to be imported, then click "Import" and map the fields imported to the fields in the database. To Export customers, click "Export".
|
Note: Customers imported that already exist will be updated. The customer password should be MD5 encrypted in the format of encrypted-password:salt. |
Categories
The "Categories" option is used to import/export category data from/to a tab-delimited text file. Categories imported that already exist will be matched by their category code (which must be unique for each category) and updated with the imported data. Category image file names may be imported with the import/export feature, but the actual image files must be placed in the "/shop/images/" directory.
When importing categories, an option to disable categories not imported is available, choose this option if you want to disable all categories other than the ones you are importing. To import categories, choose a file to be imported, then click "Import" and map the fields imported to the fields in the database. To Export categories, click "Export".
|
Notes: Categories that contain sub-categories should be imported before the sub-categories (it is best to sort the import file by parent category name). |
Products
The "Products" option is used to import/export product data from/to a tab-delimited text file. Products imported that already exist will be matched by their product model (which must be unique for each product) and updated with the imported data.
The category names must be imported (or created in the "Categories & Products" section of eShox Admin) before products are imported. As the product description field may contain return characters, you must end each product record imported with a tab and the characters 'EOR' to designate 'end of record'. Product image file names may be imported with the import/export feature, but the actual image files must be placed in the "/shop/images/" directory.
When importing products, an option to disable products not imported is available, choose this option if you want to disable all products other than the ones you are importing. To import products, choose a file to be imported, then click "Import" and map the fields imported to the fields in the database. To Export products, click "Export".
|
Notes: Products imported that already exist will be updated. Each row of data imported must end with '[tab]EOR' (designates end of record). Categories must be created before products are imported. Products with categories that do not exist will be placed in the 'top' category. Products should have one record for each language currently enabled in the store. Product images should be placed in the /shop/images directory (only the image filenames should be imported here). |
Product Options
The "Product Options Data" option is used to import/export product options data from/to a tab-delimited text file. New products options imported should have a blank product options ID field; eShox will assign an ID upon import. Product options imported that already exist will be matched by their product options ID and updated with the imported data.
When importing product options data, an option to delete existing products options is available. Choose this option if you want to delete all products options other than the ones you are importing. To import product options data, choose a file to be imported, then click "Import" and map the fields imported to the fields in the database. To Export product options data, click "Export".
|
Notes: Option names and values must be created before products are imported. Product option images should be placed in the /shop/images directory (only the image filenames should be imported here). |
