Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

is it possible to add products directly to the mysql database

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore General Questions › is it possible to add products directly to the mysql database

Tagged: add product, config, database, mysql, mysql import

  • This topic has 1 reply, 2 voices, and was last updated 13 years, 1 month ago by amin007.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • March 3, 2010 at 4:08 am #875
    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.

    March 3, 2010 at 7:51 am #18519
    amin007
    Participant

    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.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • WP PDF Stamper Documentation
  • WP Photo Seller Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial
  • WP Photo Seller Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2023 | Tips and Tricks HQ