How to Customize a WordPress Theme


Results 1 to 12 of 12

Thread: A Hilarious Error,

  1. #1
    Join Date
    Dec 2009
    Location
    Tennessee, USA
    Posts
    722

    Default 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,

  2. #2
    Join Date
    Apr 2007
    Posts
    15,314

    Default

    Yikes! And it only does this for certain products?

  3. #3
    Join Date
    Jul 2007
    Location
    Canada
    Posts
    5,209

  4. #4
    Join Date
    Dec 2007
    Location
    Alexandria, MN USA
    Posts
    6,573

    Default

    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.
    Good Success!

    Website: Success With Money
    "People will forget what you said, people will forget what you did, but people will never forget how you made them feel." —Maya Angelou

  5. #5
    Join Date
    Dec 2009
    Location
    Tennessee, USA
    Posts
    722

    Default

    Quote Originally Posted by lisa View Post
    Yikes! And it only does this for certain products?
    Only with certain list prices.

    (For Example)
    Redacted

    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.
    Last edited by zachariahlogan; 08-21-2014 at 04:51 PM.

  6. #6
    Join Date
    Dec 2009
    Location
    Tennessee, USA
    Posts
    722

    Default

    Quote Originally Posted by TechieGuy View Post
    I'll take two...no, wait...make it three.
    1. I'm not even sure if that much money exists.

    2. But I'm not a banker, will that be cash or credit?


  7. #7
    Join Date
    Dec 2009
    Location
    Tennessee, USA
    Posts
    722

    Default

    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

    List price=$100
    saleprice=$80

    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.

  8. #8
    Join Date
    Dec 2009
    Location
    Tennessee, USA
    Posts
    722

    Default

    I just got this, have been using the wp-all import plugin.

    http://www.wpallimport.com/

    Hey Zachariah,

    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.
    disable-price-fix.jpg

    Best Regards,
    Antonio Farias
    Soflyy

    disable-price-fix.jpg

  9. #9
    Join Date
    Dec 2009
    Location
    Tennessee, USA
    Posts
    722

    Default

    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.

  10. #10
    Join Date
    Dec 2009
    Location
    Tennessee, USA
    Posts
    722

    Default

    Hello again, I just wanted to post this... I'm getting traffic, very steady. I wonder if I will get any sales! screenshot2.jpg

  11. #11
    Join Date
    Dec 2009
    Location
    Tennessee, USA
    Posts
    722

    Default

    Hello, so in case anyone was wondering how I was doing.
    I'm adding a quick screenshot- on the amount of sales activity I've had on this project since I last updated.
    Not bad to say the least, I didn't realize it was in that dollar amount.

    report screenshot.jpg
    Attached Images Attached Images

  12. #12
    Join Date
    Dec 2009
    Location
    Tennessee, USA
    Posts
    722

    Default

    I'm not sure why it's showing the same picture multiple times.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •