• Resolved twilightz0ne

    (@twilightz0ne)


    I’m having an odd issues with woocommerce and paypal standard. We recently switched paypal accounts as the business grows and now are required to collect taxes. I’ve made the taxes inclusive in regions we have to collect them and am using the experimental piece of code from woocommerce so the price on site listed is the total you pay no matter what and the taxes get calculate within that amount. Now before we made the change the info being pushed to paypal was.
    OLD SYSTEM
    Order details
    Item # GLAS-SHUTTLE Space Shuttle Quantity 1

    Now however it is:
    Order details
    Item # 8657 Space Shuttle Quantity 1

    It pushes pricing and total fine in both instances but as you can see the Item is different. Per adding in taxation the item# was the SKU. After the change the item# is the order number in woocommerce. How do I make it so the item# is the SKU again it makes it easier on them picking orders and doing the accounting if the SKU is there.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there @twilightz0ne,

    Thanks for that detailed description!

    er adding in taxation the item# was the SKU. After the change the item# is the order number in woocommerce

    Where does this description show up – is this the one that shows on the customer’s bank statement?

    You mentioned changing the taxes – could you please let me know exactly which setting you changed?

    I’d like to know a bit more about your site. Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status.
    Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.

    Thanks!

    Thread Starter twilightz0ne

    (@twilightz0ne)

    In paypal:
    OLD SYSTEM

    Order details Item # GLAS-SHUTTLE Space Shuttle Quantity 1
    Price $249.00 USD
    Subtotal $289.00 USD
    Purchase total $249.00 USD

    NEW SYSTEM

    Order details
    Item # 8732 Space Mission x 1 Quantity 1
    Price $229.00 USD
    Subtotal $348.00 USD
    Purchase total $229.00 USD
    Item number since turning taxation on is the invoice number not the SKU.

    Not changing taxation just turning it on as their earning levels require it now. It was off previously.
    Setting: Yes, I will enter prices inclusive of tax is checked and taxation tables added. Paypal Standard email changed in settings to new account. I’m also using this code https://github.com/woocommerce/woocommerce/wiki/How-Taxes-Work-in-WooCommerce#prices-including-tax—experimental-behavior

    status report here: https://pastebin.com/FV8uDC1A

    Only changes were taxation turned on, tax table added. swap info for the existing paypal account .

    Thread Starter twilightz0ne

    (@twilightz0ne)

    Just to add to this I have logging on and it is sending this note the [custom] where is that in the code it is sending the wrong thing it shouldn’t be order_id but the SKU
    [cmd] => _cart
    [business] => ******redacted*********
    [no_note] => 1
    [currency_code] => USD
    [charset] => utf-8
    [rm] => 2
    [upload] => 1
    [return] => ***********redacted*********
    [cancel_return] => *******redacted***********
    [page_style] =>
    [image_url] =>
    [paymentaction] => sale
    [invoice] => CPR-8559
    [custom] =>{“order_id”:8559,”order_key”:”wc_order_**redacted**”}
    [notify_url] => ***********redacted***************
    [first_name] => ***
    [last_name] => ***
    [address1] => ***
    [address2] => ***
    [city] => ***
    [state] => ***
    [zip] => ***
    [country] => ***
    [email] => ***@***
    [night_phone_b] => ***
    [address_override] => 0
    [no_shipping] => 0
    [shipping_1] => 59.00
    [item_name_1] => Vector x 1
    [quantity_1] => 1
    [amount_1] => 159
    [item_number_1] => 8559
    [bn] => WooThemes_Cart
    )

    Thread Starter twilightz0ne

    (@twilightz0ne)

    Just to clarify shouldn’t [item_number] be the product SKU and [order_ID] be the order number? And where is that called it is picking it up wrong if that is the case.

    jessepearson

    (@jessepearson)

    Automattic Happiness Engineer

    @twilightz0ne I just did an order in my store with PayPal Standard and WooCommerce 3.6.5 and these are my (truncated) results:

    
        [cmd] => _cart
        [return] => https://local.test/checkout/order-received/120339/?key=wc_order_1r4t8fdOAJ7Vu&utm_nooverride=1
        [cancel_return] => https://local.test/cart/?cancel_order=true&order=wc_order_1r4t8fdOAJ7Vu&order_id=120339&redirect&_wpnonce=71cda6118b
        [invoice] => WC-120339
        [custom] => {"order_id":120339,"order_key":"wc_order_1r4t8fdOAJ7Vu"}
        [notify_url] => https://local.test/wc-api/WC_Gateway_Paypal/
        [no_shipping] => 1
        [tax_cart] => 33.10
        [shipping_1] => 28.40
        [item_name_1] => FedEx test
        [quantity_1] => 1
        [amount_1] => 104
        [item_number_1] => fedex
    

    Here’s the order with the ID and the product SKU:


    Link to image: https://cld.wthms.co/Kg5n9o

    It seems as of right now this is working as you say it should be. Are you still seeing this issue?

    Thread Starter twilightz0ne

    (@twilightz0ne)

    For me the order number is being replaced look at my examples. You can clearly see the invoice number and order ID are 8559. Now look at my item_number_1 it is the invoice number 8559 and not the SKU which it should be.

    Hi @twilightz0ne,

    If you take out the custom code ( as it shows it was set for ver. 2.5 and we are on 3.7 ) then set taxes to justInclusive` and have your standard tax area set, does it work on a test order? I am curious because we cannot replicate it on a few test sites of our own, and if the code being taken out works then it is something we can have the developers look at.

    If it still does not work, you may have a plugin or theme conflict, and you can do conflict testing. Please let us know if it works!

    Hi @twilightz0ne,

    I am going to close this thread for now, however if you are still having the issue just reply to this and we will re-open it.

    If you have other issues please open a new thread and let us know!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Woocommerce taxation enable change item# to order # from SKU’ is closed to new replies.