import products into eshop?

[Greg Deputy]

Is there any way to import products into eshop? I am considering moving an ecommerce site from an older cart into eshop, but there are 100's of products and many nested categories. Adding these all by hand through the ui would take weeks. I've tried, but not been successful in finding where the eshop data lives.

Thanks.

 

[Dmitry Frantsev]

All dymanic modules data, including e-shop one is stored on published side in data/storage/sb_modules.php file. This is SQLite database and has SQLite format. You can open it and try to work with it with help of 'sqlite' utility like the following:

# sqlite SITE_PUBLISHED_LOCATION/data/storage/sb_modules.php
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main SITE_PUBLISHED_LOCATION/data/storage/sb_mod
1 temp /var/tmp/sqlite_4kzD3EuuJwmclfO
sqlite> .tables
modules_5ai6aluayfj_category modules_96kpy4toiwm_day
modules_5ai6aluayfj_gallery_images modules_96kpy4toiwm_month
modules_5ai6aluayfj_gallery_relations modules_96kpy4toiwm_visitors
modules_96kpy4toiwm_attendance pr

Using sqlite commands you can try to make necessary inserts. Can suggest you to refer SQLite manuals for additional info.
Hope it helps.