Automated Invoicing Script

We would like a script to automate the sending of invoices from our BrickLink webstore. Most of the individual pieces of this process already exist as code built for other projects and we would anticipate that this script would simply tie a few of the existing pieces together and implement some additional logic. This script should be written in python to match our existing scripts and is expected to be run via cron every 15 minutes.

The script would work something like this:

[url removed, login to view] to BrickLink and download the orders list. For any orders in the “Pending” or “Updated” status with unsent invoices, invoices will need to be sent.

[url removed, login to view] the amount of postage needed using our existing shipping calculator http://shipping.cincinnatibricks.com.

[url removed, login to view] the priority mail “pin” is selected, or if the order is a domestic shipment over 1 lb use the Priority Mail rate. If the cheapest shipping “pin” is selected, use the cheapest shipping rate from the shipping calculator. If the shipping methods of “warehouse pickup” or “event delivery” are used, no shipping or insurance charges are needed.

[url removed, login to view] domestic buyers, insurance charges should be calculated at $1 per $100. Example, $[url removed, login to view] and under is $1, $100-$[url removed, login to view] is $2, $200-$[url removed, login to view] is $3, etc. For international buyers, insurance is $1 for $20 and under, then $2 per $100 afterward. Example, $20.01-$[url removed, login to view] is $2, $100.01-$[url removed, login to view] is $4, $200.01-$[url removed, login to view] is $6, etc.

[url removed, login to view] with more than 30 lots and an Order Total (merchandise only) of less than $100 have lot charges of $[url removed, login to view] per lot above 30 would be added to the “Additional Charges 1” field. Examples, a 52 lot $25 order would have $[url removed, login to view] in lot fees, but a 52 lot $125 order would have $0 in lot fees. A note (exact text will be provided) about lot fees and the lot fee total would be inserted into the invoice text if the lot fees are greater than $0.

[url removed, login to view] buyers in the state of Ohio only, the “Additional Charges 2” field would need to be calculated at 6.5% of the Order Total (merchandise only).

[url removed, login to view] the order comments to see if the buyer does not want insurance if not already done in step 4.

[url removed, login to view] the only comments are “Thank you” type comments, or if there are no comments go ahead and send the invoice.

[url removed, login to view] the payment type is “Google Wallet” or if there are other comments send an email to a specified email address with the order number as the subject and the order comments in the body so that the invoice can be sent manually.

Taidot: Python

Näytä lisää: sending invoices, sending invoice, need python code, international buyers address, international buyer address, email address buyers, automated logic, bricklink, pickup delivery, delivery pickup, domestic projects, script event, invoice calculator, invoicing address, python download, script automate, via calculator, wallet payment, pin code number, python script send email, python script download, send payment invoice, python scripts, python email send, python email

About the Employer:
( 31 reviews ) Cincinnati, United States

Projektin tunnus: #4268243

Myönnetty käyttäjälle:


We have read the requirements. Looking forward to working with you.

150 $ USD 3 päivässä
(4 arvostelua)

2 freelanceria on tarjonnut keskimäärin 200 $ tähän työhön


consider it done.!!! check pm.

250 $ USD 5 päivässä
(9 arvostelua)