I gang

order processing macro with shipping address check 2

We will do order processor for my company.

We will have 2 input files,

1) “orders” excel input file

2) “address” csv input file

And we will have 2 output files

1) “Packing List” excel output file

2) “Addresses” csv output file

In user control panel;

Ask user

Where is orders input file located?

Where is address input file located?

What is batch number?

- - - - - - - - - - - - - - - - - - -

What columns to use from orders excel input file,

Use “Buyer Name” column to combine orders from same buyer name.

Use “Total Sale” column to calculate total sale amount for this batch and put the amount in Packing List output file. See the example I made

Use “PayPal Fees Paid” column to calculate total paypal fees paid for this batch and put the amount in Packing List output file. See the example I made.

Use “Part Number” column to use in Packing List output file.

Use “Quantity Sold” column to use in Packing List output file.

Færdigheder: Microsoft Access, MySQL, PHP, Script Installering

Se mere: paypal pending order, paypal order pending, file processor, what is macro in excel, shipping company, packing , Order, order processing, macro excel, macro + excel, combine excel, combine order, macro script file, calculate quantity, excel macro csv, batch batch excel file, calculate shipping, php macro, batch file name, input file processor, order processor, php excel macro, csv files processing, php output csv, check excel files

Om arbejdsgiveren:
( 22 bedømmelser ) bangkok, Thailand

Projekt-ID: #950882

Tildelt til:

fedalal2

I can do it. Alex

$150 USD på 1 dag
(14 bedømmelser)
5.0