| Discussion Forum: Thread 291712 |
|
 |
| | | Author: | runner.caller  | | Posted: | Jun 22, 2021 15:55 | | Subject: | XML mass update to delete cost? | | Viewed: | 64 times | | Topic: | Selling | |
|
| I'm attempting to amortize all the costs of my parts into my minifigures
and it's easy enough to do in excel and xml, but when I go to upload the
new costs of the parts to $0.00, I get an error message.
1. My Cost cannot be zero
Why can my cost not be Mass Inventory Updated to $0 ?
|
|
| | | | | |
| | | | | Author: | SylvainLS | | Posted: | Jun 22, 2021 15:57 | | Subject: | Re: XML mass update to delete cost? | | Viewed: | 29 times | | Topic: | Selling | |
|
| In Selling, runner.caller writes:
| | I'm attempting to amortize all the costs of my parts into my minifigures
and it's easy enough to do in excel and xml, but when I go to upload the
new costs of the parts to $0.00, I get an error message.
1. My Cost cannot be zero
Why can my cost not be Mass Inventory Updated to $0 ?
|
What if you don’t include the field (row) at all? (Let it use the default value.)
|
|
| | | | | | | | | |
| | | | | | | Author: | runner.caller | | Posted: | Jun 22, 2021 16:05 | | Subject: | Re: XML mass update to delete cost? | | Viewed: | 33 times | | Topic: | Selling | |
|
| In Selling, SylvainLS writes:
| | In Selling, runner.caller writes:
| | I'm attempting to amortize all the costs of my parts into my minifigures
and it's easy enough to do in excel and xml, but when I go to upload the
new costs of the parts to $0.00, I get an error message.
1. My Cost cannot be zero
Why can my cost not be Mass Inventory Updated to $0 ?
|
What if you don’t include the field (row) at all? (Let it use the default value.)
|
Tried that, but then it just remains unchanged so if that inventory lot already
had cost, then it will still have its old cost.
However, I found a workaround! I just enter in a cost with a bunch of zeros after
the decimal and it uploads as $0.000 cost without erroring out.
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | SylvainLS | | Posted: | Jun 22, 2021 16:14 | | Subject: | Re: XML mass update to delete cost? | | Viewed: | 24 times | | Topic: | Selling | |
|
| In Selling, runner.caller writes:
| | In Selling, SylvainLS writes:
| | In Selling, runner.caller writes:
| | I'm attempting to amortize all the costs of my parts into my minifigures
and it's easy enough to do in excel and xml, but when I go to upload the
new costs of the parts to $0.00, I get an error message.
1. My Cost cannot be zero
Why can my cost not be Mass Inventory Updated to $0 ?
|
What if you don’t include the field (row) at all? (Let it use the default value.)
|
Tried that, but then it just remains unchanged so if that inventory lot already
had cost, then it will still have its old cost.
|
Ah, yes, the default value is the old value, so rather useless 
| | However, I found a workaround! I just enter in a cost with a bunch of zeros after
the decimal and it uploads as $0.000 cost without erroring out.
|
So the test is on integer 0 (or even string “0”), not floatting point 0.0. Well,
sometimes little errors have their usefulness 
|
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | Author: | Andrsv | | Posted: | Jun 22, 2021 16:47 | | Subject: | Re: XML mass update to delete cost? | | Viewed: | 35 times | | Topic: | Selling | |
|
| In Selling, SylvainLS writes:
| | In Selling, runner.caller writes:
| | In Selling, SylvainLS writes:
| | In Selling, runner.caller writes:
| | I'm attempting to amortize all the costs of my parts into my minifigures
and it's easy enough to do in excel and xml, but when I go to upload the
new costs of the parts to $0.00, I get an error message.
1. My Cost cannot be zero
Why can my cost not be Mass Inventory Updated to $0 ?
|
What if you don’t include the field (row) at all? (Let it use the default value.)
|
Tried that, but then it just remains unchanged so if that inventory lot already
had cost, then it will still have its old cost.
|
Ah, yes, the default value is the old value, so rather useless
| | However, I found a workaround! I just enter in a cost with a bunch of zeros after
the decimal and it uploads as $0.000 cost without erroring out.
|
So the test is on integer 0 (or even string “0”), not floatting point 0.0. Well,
sometimes little errors have their usefulness
|
I believe what he is saying is that 0.00 won't work. But 0.0000001 will work
and it will round down do 0.00.
If I remember correctly from my previous experience, the check for valid number
checks if number is larger than 0, but rounding to 2 or 3 decimals (depending
on your settings) is done after check.
Something tells me that old bricklink code didn't have much unit tests 
|
|
|
|
|
|
|
USA, South Dakota
France, Nouvelle-Aquitaine
Norway, Rogaland