Order Import

SmithCart > Integration > Import

The order import allows you to import order data from a CSV file.  The order import populates the customer, order, order detail, and payment history tables.  Additionally, the order import will create a DNN user account and profile for a customer if one does not exists.

  Click here to download sample CSV

 

To import orders, navigate to the BuyNow module and select "Setup -> Import" from the admin menu:
 

 

 

Select the "Order Import" tab:

 

Step 1:  Choose a File

Click the Browse button and select the CSV file to import.

Step 2:  Configure Options

Check the checkbox titled “First Row Includes Column Headers” if the first row of you data includes column headers.

Next, select the delimiter you used to separate fields in your input file. Pipe and Comma are supported delimiters. It is recommended that you use the “Pipe” delimiter as the pipe delimiter has a lower chance of showing up in the actual data fields you are importing, thus increasing the likelihood that your input file will be successfully imported.

Step 3:  Import Now

To import the selected CSV, click the Import Now button to start the import.

When the import is complete, a message stating that the import was successful is displayed.

Note: This process may take several minutes, depending on the number of records to be imported. You should also allow time for the data to be processed: for example, it should take about half a minute to import 100 records, five minutes to import 1,000 and so on.

 

Import Field Specification

The import file can be in one of the following two formats:

  • Pipe Delimited (Recommended)
  • Comma Delimited (CSV)
Field Name Field Format Rqd Description

FirstName

String

Yes

Customer First Name

LastName

String

Yes

Customer Last Name

Address1

String

Yes

Customer Address 1

Address2

String

 

Customer Address 2

City

String

Yes

Customer City

Country

String (2)

Yes

Customer Country

State

String (2)

Yes

Customer State

Zip

String

Yes

Customer Postal Code

HomePhone

String

 

Customer Home Phone

CellPhone

String

 

Customer Cell Phone

WorkPhone

String

 

Customer Work Phone

Email

String

Yes

Customer Email

DNNLogin

String

Yes

Customer DNN Login

CompanyName

String

 

Customer Company Name

OrderID

String

Yes

Order ID

OrderDate

DateTime (MMDDYYYY)

Yes

Populate with today’s date if no input value exists

OrderStatus

String

Yes

Status of the Order (Open, Closed, Cancelled, Shipped, Warehouse , BillMeLater)

ShipFirstName

String

   

ShipLastName

String

   

ShipAddress1

String

   

ShipAddress2

String

   

ShipCity

String

   

ShipState

String

   

ShipZipcode

String

   

ShipCountry

String

   

ShipMethod

String

   

ShippingTotal

Decimal

   

HandlingCharge

Decimal

   

TaxTotal

Decimal

Yes

 

Surcharge

Decimal

   

CouponId

Integer

   

Discount

Decimal

   

MemberDiscount

Decimal

   

MemberRole

String

   

AffiliateId

String

   

ProductID

String

Yes

 

ProductName

String

Yes

 

ProductSKU

String

Yes

 

Quantity

Integer

Yes

Populate with 1 if no input value exists

UnitCost

Decimal

Yes

 

TaxRate

Decimal

   

SerialNumber

String

   

BillingName

String

Yes

 

BillingAddress

String

Yes

 

BillingCity

String

Yes

 

BillingState

String

Yes

 

BillingZip

String

Yes

 

BillingCountry

String

Yes

 

PayType

String

Yes

 

OrderTotal

Decimal

Yes

 

AccountNumber

String

Yes

 

ExpRoute

String (MMYY)

Yes

 

CVV

String

 

Credit card security code

TransID

String

Yes

Payment transaction id

Notes

String

 

Payment processing notes

PaymentStatus

String

Yes

Approved or Declined

AuthCode

String

 

Payment authorization code

InvoiceNo

String

No

Invoice number used on payment

PONumber

String

No

Purchase order number used for payment