Creating Quickbooks IIF import file for eCommerce orders
$30-100 USD
Paid on delivery
I have an eCommerce site where I get orders. Buyers visit the site, add to cart, pay and then I ship.
I have the order information saved to a database. But you can give me doctored dummy data (iif file edited in notepad) so that I can test
A)
The IIF file should contain all the information about the order that I capture, the information being
? OrderID
? OrderDate
? CustomerDetail (name, address, state, country etc..)
? ItemDetail (such as SKU, Title,weight)
? Price
? Qty
? LineTotal (Price * Qty)
? PromotionAmount
? SalesTax
? Shipping
? OrderTotal
? CreditCard commission
? USPS delivery charge
When this data is imported, then for this specific order, I should as many lines in the QuickBooks under one order entry for all the total affecting transactions
For example
OrderID: 9001
OrderDate: 01/01/2009
LineTotal: $24.99
Promotion: -$1
SalesTax: $5
Shipping: $10
CreditCardCommission: -$6.30
USPSDelivery charge: -$2.50
When imported to quickbooks, the specifc order entry in quickboos? must have 5 lines, three postive? amounts going to "Income" account (except SalesTax going to SalesTax account)? and? 3 negative amounts? going to expense account (CreditCardCommission going to "BankFee" expense account and USPS-DeliveryCharge going to "Postage and Delivery" expnse accont) and the transaction should be recored as net of
The quick entry net amount =
? ? ? LineTotal
? ? ? + SalesTax
? ? ? -? Promotion
? ? ? + Shipping
? ? ? ? -? CreditCardCommission
? ? ? ? - USPSDelivery charge
B)
If an order is modified at later time, such USPS Delivery charge added, the if re-imported, the existing entry in quickbook should be modified instead of creating a new entry so that it reflects correct net amount,
C)
If an order is cancelled at a later time, proper entry should be imported into Quickbooks
D)
There should be way to import customer information into Quickbooks
Project ID: #3683080
