But when I import about 2,800 Shopify POS rows via CSV, any transaction with a markdown splits into two lines on save — full price and a separate discount — and this keeps showing up. It happens in both QuickBooks Online and NetSuite when the column is named Discount; renaming it to Promo stopped it once, then it returned today — anyone have a stable mapping that prevents the double-post?
I hit this with about 2,800 Shopify POS rows in QBO — . “It happens in both QuickBooks Online and NetSuite when the column is named Discount; renaming it to” same result for me; the safest fix was to pre-calc a NetRate in the CSV and map only Qty + Rate/Amount, leave Discount completely unmapped, and turn off the QBO discount field so it can’t spawn a second line. If you still need the code, stash it in Memo/Custom Field, not as a discount column.
Quick fix that’s stuck for me: strip the ‘Discount’ column entirely and map a computed header ‘Discount %’ instead (total_discount/pretax_total), then in QBO use the Discount Percent field and in NetSuite map to a header Discount Item — no more split lines. I tried the ‘renaming it to “Promo” stopped it once’ trick too; , it came back until I moved all discounts to the header — have you tried that?