Does anyone have an example .CSV file with two or three records with orders for more than one item? I want to get ahead of the game and edit my invoice mailmerge file for when I add a product. Right now, I only have one product, but I need to see what the file looks like if someone orders two products. IOW, right now, the fields are order id, product title, unit price, qty, item total, etc. Does it just repeat these lines with the same order number so I need to do a calculation to figure out which items belong on the same invoice. IOW, does it look like this:
order id, order total, model number, unit price, quantity, item total
1000, 50.00, Arduino Board, 30, 1, 30
1000, 50.00, ESP32 Board, 10, 2, 20
2000 - 30, Arduino Board, 30, 1, 30
It would be nice to have an actual file to be able to see exactly what Tindie puts into each of those fields for a store with multiple items.