Manuyally scan each of these lines to remove all duplicate Couple of little changes I can see if you can help, Otherwise I will be scanning each line 1 by 1 to make sure I charge correctly where they have purchased a ski slope 3 example below
Example Line 1 – could I have the column in where it shows we have only dispatched 1 unit to them as when we place the order on mint we select 1/2/3 etc
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Channel |
External Order Reference |
Order Date |
Order Value |
Product Name |
Order Shipping Cost |
|
Manual Input |
5276 Harry Agnew - M |
01/08/2022 11:54 |
50.69 |
HNZSAM Heinz Ski Slope (NEW) |
8.95 |
|
Line 14 - the charges appear twice in the columns whereas the £94 charge that we have entered is for the full cost of both units not each and the dispatch charge is £8.95 for both not each
HNZSAM |
Manual Input |
5276 steve ewell - m |
03/08/2022 09:30 |
94 |
HNZSAM Heinz SOM 2.5l Cream Mayonnaise |
8.95 |
HNZSAM |
Manual Input |
5276 steve ewell - m |
03/08/2022 09:30 |
94 |
HNZSAM Heinz SOM 2.5l Red Tomato Ketchup (TK) |
8.95 |
Line 29
Similar to the above, This is showing as £186.00 for every line we have dispatched whereas the charge should only be once for the complete order of samples we have charged a pallet dispatch charge
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 2.15Ltr Tomato Salsa |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 5Ltr Professional Pail |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 875ml BBQ Classic |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 2.15Ltr Texan BBQ |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 875ml Sweet Chilli |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 875ml 1kg Tomato Ketchup |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 25gm BBq Dip pot |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 25gm Garlic Sauce Dip pot |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 875ml Mayonnaise |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 875ml Classic Burger Sauce |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 875ml Firecracker |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 875ml Garlic sauce |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 875ml Korean BBQ |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 342gm Tk Opaque Squeezy |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 285gm HP Brown |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 220ml Seriously Good Mayonnaise |
186 |
HNZSAM |
Manual Input |
5276 CHERYL GRUNDY |
04/08/2022 09:59 |
0 |
HnzSam 415gm Heinz Beans |
186 |
