Finding a solution to move SQL data from another source to WooCommerce database

  • Resolved joel2052

    (@joel2052)


    3 years, 2 months ago

    Hello, I am currently in the planning stage of moving our website to WordPress, but we ran into a few problems with the SQL database.
    We don’t have much experience with WooCommerce.

    Our current ASP website is running on Microsoft IIS. The website’s SQL database (MySQL) is linked to our own rental asset management system written in house (database is on MS SQL17). It can update our product pages automatically each night by updating the SQL records on the website. Database type is MyISAM.

    The issue is that I need to find the best solution to move mass product data (over 1000 records) from our in house rental asset management database to WooCommerce each night automatically.

    Is there a way to upload our SQL database to a program script and populate a WooCommerce product database each night?
    We prefer running on client-side then online service.

    Can someone please suggest to me how to solve this issue, some details will be much appreciated.

    Thank you.

Viewing 7 replies - 1 through 7 (of 7 total)

  • @joel2052

    WooCommerce offers a csv import process you can find here: https://woocommerce.com/document/product-csv-importer-exporter/

    You may also checkout this guide for further help

    Thread Starter joel2052

    (@joel2052)

    Thanks for the reply Oyadeyi, I am having issues now with the WooCommerce CSV import. It will not use my prefer CSV Delimiter. It keep using comma even I change it to | pipe character. I am using Version 6.1.1 Can you please advice me what I can do?

    Plugin Support Sérgio L. a11n

    (@csnlima)

    Hi @joel2052!

    Can you please confirm what CSV editor are you using? If possible, avoid Microsoft Excel due to formatting and character encoding issues. These are the editors we recommend:

    Online spreadsheet editor Google Drive / Docs
    Free spreadsheet app in OpenOffice
    Free Calc app in LibreOffice
    Numbers for macOS

    If you are using one of these editors and the CSV delimiter is still now working, to get a better understanding of your setup, could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Best,

    Thread Starter joel2052

    (@joel2052)

    Thank you csnlima, after saving to csv from Google Sheet it works.

    One last thing is there an option to delete all products per import? So that each import will have a new list of products. I am aware that you can do bulk action delete 20 or more products using woocommerce UI manually, but takes along time to delete over 1000 records.

    Please let me know if there is a quicker way, thank you.

    Plugin Support Paulo P – a11n

    (@paulostp)

    Hello,

    Products in WooCommerce are WordPress posts, so any tool that can remove posts should work.

    To delete products in bulk, you could go via the plugin route with something like this.

    Or

    Use WP-CLI to send the request to your server via the command line, like mentioned here.

    Hope this helps, let us know if we can be of any further assistance.

    Thread Starter joel2052

    (@joel2052)

    Thank you for your time and help, we have found a solution.

    Great! Thanks for letting us know.

    Please feel free to open a new thread if you have more questions.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Finding a solution to move SQL data from another source to WooCommerce database’ is closed to new replies.