Creating Quickbooks IIF import file for eCommerce orders(repost)

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

Ingeniería MySQL PHP Gestión de proyectos Arquitectura de software Verificación de software

Nº del proyecto: #3686196

Sobre el proyecto