- Support forum for the Cost of Goods Sold (COGS): Cost & Profit Calculator for WooCommerce.
- November 11, 2020 at 9:09 am #89451MaxGuest
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.November 11, 2020 at 3:04 pm #89452
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 😉November 11, 2020 at 3:09 pm #89453MaxGuest
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 …”.November 11, 2020 at 4:58 pm #89454
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 tooNovember 11, 2020 at 5:04 pm #89455MaxGuest
Hello, I send CSV file to Your email 😉
Max.November 11, 2020 at 10:18 pm #89456
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:
And it should be like this:
value1,value,value3November 12, 2020 at 9:45 am #89457MaxGuest
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.November 12, 2020 at 5:27 pm #89458
You’re welcome 🙂
I believe you can name the column titles as you want.
Let me know if it works 😉November 12, 2020 at 6:14 pm #89459
Just a note that could be useful.
If you add the title of the cost column as
it will be automatically mapped on the import. This way would be easier as you wouldn’t even have to select “Cost” for that columnNovember 13, 2020 at 12:15 pm #89460MaxGuest
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.November 13, 2020 at 3:35 pm #89461
That sounds right 😉November 13, 2020 at 5:41 pm #89462MaxGuest
Hello, with this settings import change my Cost 😉
Thanks.November 13, 2020 at 8:41 pm #89463
- You must be logged in to reply to this topic.