Importing rules from CSV file?

  • Machtnix

    (@hillyfov)


    1 year, 8 months ago

    Hello,

    I just wanted to ask if you could help me with importing pricing rules and product lists from a CSV file.

    I was unable to find out how the product list configuration and the pricing rule configurations are stored. Can you please help me with this? I need to know whether they are stored as options, custom fields or taxonomies so I know how to name the columns in my CSV file.

    Thank you!

Viewing 1 replies (of 1 total)
  • Thread Starter Machtnix

    (@hillyfov)

    1 year, 8 months ago

    Okay so I found out the configurations are stored in the postmeta table in the database.

    I am having trouble importing the configuration values via csv though. I have exported my existing pricing rules and product lists and tried importing the file. The rules are imported without giving errors. But I can not open/edit their details in WordPress admin because the page keeps loading as soon as I click on one of my imported rules.

    I think the problem is trying to import the configuration array which looks like this (example product list configuration):
    a:6:{s:16:"selectedProducts";a:1:{i:0;i:643;}s:13:"productAuthor";s:0:"";s:16:"excludedProducts";a:0:{}s:11:"taxRelation";N;s:5:"rules";a:0:{}s:15:"selectionMethod";N;}

    This looks like this in the database after import:

    s:168:"a:6:{s:16:"selectedProducts";a:1:{i:0;i:734;}s:13:"productAuthor";s:0:"";s:16:"excludedProducts";a:0:{}s:11:"taxRelation";N;s:5:"rules";a:0:{}s:15:"selectionMethod";N;}";

    How can I fix this?

    • This reply was modified 1 year, 8 months ago by Machtnix.
Viewing 1 replies (of 1 total)
  • The topic ‘Importing rules from CSV file?’ is closed to new replies.