A Hilarious Error,
Hello. so, I think I need a little advise on this,
I am uploading some xml files into woo commerce through wp-all import.
Pretty nifty tool if I do say so myself.
But there is an issue, I have a set markup, (or multiplier) that I have on the website. So what I did was
multiply list times 20% plus list.
Which takes 20% off of list, (don't worry it's standard in this industry the market is terrible)
So, what my problem is, in most cases for example the list would be 100$ then take (20$) and sell it at 80$ but for a few prices I get, a, very long decimal. for example,
79.99999999 (sale price)
which is fine, except when I import it, woo-commerce instead of reading it like 79.99 or 80, it reads it like,
799,999,999,999 quintillion. Hilarious indeed, but I doubt I would find anybody who would buy it at that price. Especially when it is an $80 part,
Yikes! And it only does this for certain products?
I'll take two...no, wait...make it three.
No one would buy it? You are just looking at the wrong customer base. The government is well known for buying without consideration for real life prices. Check with the Department of Defense. You might be rich before you know it.
Douglas County Master Gardeners
"People will forget what you said, people will forget what you did, but people will never forget how you made them feel."
Only with certain list prices.
Originally Posted by lisa
Product 100141's recomended retail is, $1,563.00
I buy it for 703.35, and then sell it at List (1563.00) - 20%, which in readable form would be $1,250.40
(which is 1563-1563 *.2)
But as you can see in the link it added, 13 extra zeros.
Which doesn't make sense with what I said earlier....
now I'm not even sure why it's doing that.... I thought because it was a long decimal, and woocommerce just read it wrong. But... Even computers know to knock off extra zero's....
So even if it was, 1,2504.00x10^11 (13 zeros after decimal) It should still read right... Now I'm just confused.
I'm manually updating them.
So, I was updating the prices manually. Then i noticed something,
I was having one of my employees do the update, I explained how to do it, and let's just say it was slow....
So then I copied and pasted the excel (xml) sheet into Google Spreadsheets.
Something interesting happened.
It copied the face value and not the equations.
So instead of something like,
list price =$100
Sale prices=listprice X 20% + List price
It just went
no equation, which i'm presuming is the reason the whole thing goofed up to begin with, but of course before I upload it, I'm gonna test it on a sandbox site.
But interesting none the less!
Saved hundreds of hours.
I'm presuming what I will do, is then copy the google spreadsheet data, into a new xml db.
and I predict since the equation did not copy into google spreadsheets, it will not copy into a new xml spread sheet.
I will advise momentarily.
As predicted the equation did not copy, just the result of the equation. !
Last edited by zachariahlogan; 06-01-2014 at 01:40 PM.
I just got this, have been using the wp-all import plugin.
This issue is caused by a built-in function that tries to fix improperly formatted prices. You can disable this through the Add-On Optiions tab for the WooCommerce Products screen. See the attached screenshot for reference.
I hope this information helps and let me know if you have any other questions.
So I'm running a small ad campaign on facebook.
I'll let you know how it goes.
Being a B2B online store, there are a lot of questions I want answers to. Like, does it work?
I know companies like Granger do it, but can I do it. With these products?
This will be interesting to say the least, I'll post my results here later.
and since tomorrow is the official launch, I'm running a promotional coupon. Today, and will be doing a larger one tomorrow. IF I can gather enough data from this campaign today.
Hello again, I just wanted to post this... I'm getting traffic, very steady. I wonder if I will get any sales! screenshot2.jpg