close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Use old Ecart database with Powerstore

Thread began 1/31/2012 7:09 am by hcollins356518 | Last modified 2/01/2012 9:37 am by Jason Byrnes | 1204 views | 4 replies |

hcollins356518

Use old Ecart database with Powerstore

Have an existing website created with Dreamweaver and Ecart extension that isn't working properly. Want to use existing product database which contains over 3,000 records with Powerstore. Installed Powerstore and tested transaction with default Powerstore product database structure and it worked fine. The Powerstore database needs to be restructured to include fields from the old database. Tried restructuring the old database to include fields from Powerstore ps4_product database and renamed to ps4_product and the application became unusable. Reinstalled several times to correct this issue with no success. Is there a straightforward to migrate my old product and customer database over to Powerstore?

Sign in to reply to this post

Jason ByrnesWebAssist

no, using an existing products table with Power Store will not work.

there is no strait forward way to export the existing product info to the power store products table.


you would need to edit the existing product database to use the same column names and data types as the power store products table, just changing the name of the table will not suffice.

Sign in to reply to this post

hcollins356518

Migrating from Ecart to Powerstore

Screwed again! You mean that there is no way to move existing product info from Ecart to Powerstore? If that is the case, the product is no use to me and I need a refund. I am not inputting 3,000+ product into the Powerstore database.

Sign in to reply to this post

Ian S

"Screwed again!"

eCart is not a product database. It provides the front end functionality in terms of the shopping cart. The database that sits behind eCart can take infinite structures as its down to how the developer puts the solution together.

Powerstore is a pre-built solution with a pre-defined structure.

You simply cannot migrate from an unknown quantity to a defined structure. That's a crazy request / expectation. If you wanted a migration tool writing you would need to talk to the developers of your eCart based solution.

Sign in to reply to this post

Jason ByrnesWebAssist

what Ian says is true.

but if you read the entirety of my initial reply, I do give some advice on how you may be able to get the product info into the power store data base:

  you would need to edit the existing product database to use the same column names and data types as the power store products table,  



look carefully at the structure of the power store products table, the column names and data types.

if you edit the structure of your existing products table to match the power store products table, it may work.

you may need to add columns or remove some that are not relevant to power store.

the key to success with this is matching the names and data types. It will take some patience, and experimentation to get it right. I would suggest making a back up before you start.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...