acidonyx
Forum Replies Created
-
Why don’t make a copy of your site locally and test it there first? This way there will be no risk involved;)
Good luck!
You should try and see.
For you situation, I would make a full backup of the site and DB first, or even better make a temporary copy of the site on local host and then try to:
1) Export all existing products
2) Edit CSV to delete both columns in question
3) Import CSV back with the ‘merge’ option.If that will not work, I would next try this:
1) Restore previous backup (if necessary)
2) Export all existing products. I would pay attention to make sure all the listing info is exported including images info, etc.
3) Edit CSV to delete both columns in question
4) Delete all products you’ve exported from the store
3) Import CSV back to recreate the productsLet us know the results!
I was waiting for them to fix it latest release, did 3.3 just came out?
There is a workaround to make it work: in csv file that you are planning to import, delete both Download Limit and Download Expiry columns completely (including the headers). It will result in product having unlimited values in Download Limit and Download Expiry columns.
I will test 3.3 some time later, and will reach the support again if needed to escalate this bug report so it will hopefully get fixed.
Thanks for your reply, Doug!
I do use core Importer/Exporter for this. I also found Product CSV Import Schema prior posting this.
It was a little unclear what “set to n/a” means.
I tried to set the column value to “n/a” – got 0 on import
I tried to leave the column value blank – got 0 on importI just tried to delete both Download Limit and Download Expiry columns and it finally worked – got blank “unlimited” fields in imported product.
But what should I do if I import multiple products at once with some having download_limit set and some don’t? Deleting the columns is no longer an option.
The whole thing is very confusing:
1) Documentation doesn’t make it clear that setting to “n/a” means deleting the column.
2) Exporting existing product with blank values generates CSV with both columns presented and set to -1. Yet re-import same CSV sets both fields to 0.Is this an intended behavior?
P.S: I contacted Woocommerce directly through the site and just received a reply that an issue was created on Github as a result – https://github.com/woocommerce/woocommerce/issues/18360