Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

Upload database of products


3 replies to this topic

#1 ericjb9

  • Community Member
  • 3 posts
  • Real Name:Eric Bergman

Posted 07 April 2011, 20:19

I am wondering if it is possible to upload a mysql database of all products I want on the store. I did not see an option in the admin area. I did not want to have to manually insert each name, price, and description for each product since I have a large amount of products. I want to upload a mysql database I built and have it automatically populate the store. Is this possible?

#2 catalano

  • Community Member
  • 106 posts
  • Real Name:Chris Catalano

Posted 08 April 2011, 14:38

Check out the Apsona shopadmin addon. We just started working with it. It will allow you to start with an Excel spreadsheet of your data (which you should be able to create from your sql dump) and import it directly into OSC. Also allows you to dump your shop data back to the spreadsheet, make changes, and bring it back. Looks pretty good so far.

Good Luck,
CJ

View Postericjb9, on 07 April 2011, 20:19, said:

I am wondering if it is possible to upload a mysql database of all products I want on the store. I did not see an option in the admin area. I did not want to have to manually insert each name, price, and description for each product since I have a large amount of products. I want to upload a mysql database I built and have it automatically populate the store. Is this possible?


#3 ericjb9

  • Community Member
  • 3 posts
  • Real Name:Eric Bergman

Posted 08 April 2011, 16:03

View Postcatalano, on 08 April 2011, 14:38, said:

Check out the Apsona shopadmin addon. We just started working with it. It will allow you to start with an Excel spreadsheet of your data (which you should be able to create from your sql dump) and import it directly into OSC. Also allows you to dump your shop data back to the spreadsheet, make changes, and bring it back. Looks pretty good so far.

Good Luck,
CJ

Thank you very much. It is working out nicely.

#4 ozstar

  • Community Member
  • 515 posts
  • Real Name:David
  • Gender:Male
  • Location:Sydney OZ

Posted 14 May 2011, 10:28

How you guys going with Apsona?

I am stumped when importing in 'orders'. The $amount is not in the order table so is not imported. Any help?

Thanks

oz