Tips and Tricks HQ Forum

Support Forum for Tips and Tricks HQ Products

Register or log in - lost password?

Search the Forum

Tips and Tricks HQ Forum » WP eStore Forum » WP eStore General Questions

is it possible to add products directly to the mysql database

(2 posts) (2 voices)
  • Started 1 year ago by chardixon
  • Latest reply from amin007
  • Related Topics:
    1. Adding extra info from SQL to display member details
    2. Variation for downloadable products
    3. How to import my SQL user database
    4. Saving subscribe button spikes CPU usage
    5. The wp_eStore download manager ran into a problem

Tags:

  • add product
  • config
  • database
  • mysql
  • mysql import
  1. chardixon
    Member

    I would like to know if it is possible to add products directly into the mysql database, rather than going through the product addition page for each of the 1500 products i need to add.

    if anyone has experience with this, your knowledge would be greatly appreciated.

    Posted 1 year ago #
  2. amin007
    Key Master

    Yes, it is possible to upload product details directly into mysql database but eStore doesn't have any build in function for this yet.

    There are a few different ways to do this... you could write a PHP script that opens your data file (excel file), break it up into an array of lines that each represent a row of data, split each line up by the delimiter character (such as a comma ',', tab '\t', semicolon ';', space ' ', etc.), and then perform invididual MySQL INSERT queries (one INSERT for each line) to insert all your data from the file into the appropriate table fields.

    Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.

Tips and Tricks HQ Forum is proudly powered by bbPress

Tips and Tricks HQ  | WP Shopping Cart  | WP Affiliate Software  | WordPress Membership Plugin