How to Integrate with Prostores?

[team2powersports]

I currently use prostores for evrything and I am getting sick and tired of everything with the prostores cart especially the FVF's they charge etc...I also really like the way osCommerce seems to work on others sites. Does anyone know how to use osCommerce with prostores or where I would begin? Is osCommerce similar to prostores in the sense that I design everything on my site with osCommerce or can I still do that with prostores? If it can be used with prostores, how do I set it up and is there anyway to transfer my catalog items from prostores into osCommerce or do I have to redo everything? I am new at this so please forgive me. Hope for some great help! Thanks!

[free hugs]

I currently use prostores for evrything and I am getting sick and tired of everything with the prostores cart especially the FVF's they charge etc...I also really like the way osCommerce seems to work on others sites. Does anyone know how to use osCommerce with prostores or where I would begin? Is osCommerce similar to prostores in the sense that I design everything on my site with osCommerce or can I still do that with prostores? If it can be used with prostores, how do I set it up and is there anyway to transfer my catalog items from prostores into osCommerce or do I have to redo everything? I am new at this so please forgive me. Hope for some great help! Thanks!

 

 

I just switched from prostores.

 

ProStores is written in a way that limits the ability to modify the database structure or the actual code, beyond the little "prostores SSML" tags that are enabled. These aren't a substitute for a full-fledged scripting language like PHP. With oscommerce, literally, the sky is the limit with your modifications.

 

You can't use osCommerce on a prostores site. They don't have MySQL or PHP installed.

 

There is no "easy" way to move your catalog from ProStores to OSC.

This is how I did it:

 

Create Product Category Structure in OSC

Export your catalog to a tab delimited file.

Import into Access.

Do a "Find-Replace" to convert old Category to new CategoryID using the structure you just created in OSC

Delete unnecessary columns.

Export to delimited text file using ; and double quotes for field values (seemed to be the least messy).

Import file into a new table called "fromprostores" with matching column fields / settings.

Use SQL to transfer items to the proper OSC tables. (Pretty simply INSERT SELECT statements and UPDATE with LEFT JOIN.)

 

Viola! Your catalog will magically appear.

Keep in mind you have to transfer your pictures from ProStores to the images/ directory in OSC.

 

Good Luck!