How to import costs from a CSV file?

Top WooCommerce & WordPress Plugins Forums Cost of Goods for WooCommerce How to import costs from a CSV file?

Viewing 13 posts - 1 through 13 (of 13 total)
  • Author
    Posts
  • #89451
    blankMax
    Guest

    Hello everyone, I have a problem with Cost of Goods plugin … I need to update purchase costs every time I receive a price list with products; then I use the Import function of WooCommerce and load the list as a CSV file and then leave the “Update existing products” option enabled … when the list of items to import appears I select only COD (aka SKU) by entering unique code of the product to be update and the purchase cost by selecting Cost from the drop-down menu; at that point I import the file but, at the end of the procedure, I check the purchase costs of products and they have not changed.
    Can you help me?
    Thanks.

    #89452
    blankWPFactory Plugins
    Participant
    Plugin Author

    Hi Max,

    Besides leaving the “Update existing products” option enabled, also make sure to:
    – Leave the “ID” column mapped properly as ID. Don’t mark it as “Do not import”

    Let me know if it works 😉

    #89453
    blankMax
    Guest

    Hello, is what I write into my first message: “… when the list of items to import appears I select only COD (aka SKU) by entering unique code of the product to be update …”.

    #89454
    blankWPFactory Plugins
    Participant
    Plugin Author

    Can you please send me the file you’re trying to import, so I can take a look?
    You can send it to [email protected].

    If it’s very big or if it’s easier, you could try to upload it somewhere and send me the link via e-mail too

    #89455
    blankMax
    Guest

    Hello, I send CSV file to Your email 😉
    Max.

    #89456
    blankWPFactory Plugins
    Participant
    Plugin Author

    Hey Max,
    I was looking into the CSV you sent me.

    There seems to be a problem.
    The CSV file doesn’t have column titles and apparently WooCommerce needs that to run the import properly.

    For example, imagine if your csv file only had 3 columns. Currently it’s like this:
    ,,
    value1,value2,value3

    And it should be like this:
    Col1,Col2,Col3
    value1,value,value3

    #89457
    blankMax
    Guest

    Hello, thanks for Your reply.
    So I have to add column title before val1, val2, val3, etc.?
    Do the column titles have to be exactly the same as the entries present at the time of import (like in this URL: https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting) or I just have to add column title about my CSV?
    Thanks.

    #89458
    blankWPFactory Plugins
    Participant
    Plugin Author

    You’re welcome 🙂

    I believe you can name the column titles as you want.
    Let me know if it works 😉

    #89459
    blankWPFactory Plugins
    Participant
    Plugin Author

    Just a note that could be useful.
    If you add the title of the cost column as

    "Meta: _alg_wc_cog_cost"

    it will be automatically mapped on the import. This way would be easier as you wouldn’t even have to select “Cost” for that column

    #89460
    blankMax
    Guest

    Hello, I add “Meta: _alg_wc_cog_cost” title on Cost column in my CSV file…so I import it and, instead Cost from dropdown, will be “import like metadata” automatically into choosing what data import page, is correct?
    Then I select COD (not ID, COD) for my products COD/SKU, is correct?
    Thanks.

    #89461
    blankWPFactory Plugins
    Participant
    Plugin Author

    That sounds right 😉

    #89462
    blankMax
    Guest

    Hello, with this settings import change my Cost 😉
    Thanks.

    #89463
    blankWPFactory Plugins
    Participant
    Plugin Author

    Glad to hear it Max!

    In that case, please consider leaving a review here or here if you are enjoying the plugin/support. It would be much appreciated 🙂

Viewing 13 posts - 1 through 13 (of 13 total)
  • You must be logged in to reply to this topic.