User Tools

Site Tools


urfsales:documentation

uRapidFlow Sales

What is uRapidFlow Sales?

The uRapidFlow Sales is the Magento extension that allows the user to perform both import and export operations for the Magento Sales section. This may be useful in case you need:

  1. import/export sales data such as
    1. Recurring Profiles {afaik, this section in Magento has never worked correctly}
  2. add/update the desired fields;
  3. synchronize/migrate data between Magento installations;
  4. use remote location on FTP to perform such operations;
  5. use single and batch scheduling via cron jobs.

Getting Started

To handle the import/export operations, the user needs to create the profiles for this. These profiles are the configurations that allow the user to perform several activities. Creating separate profiles for separate activities rather than modifying the only profile is a good practice as you may need to perform some operations regularly. After the profile is configured, the user can run them from the list of the Profiles or via cron jobs. As part of the uRapidFlow extension, uRapidFlow Sales shares the same location for managing Profiles. Please open System → Rapidflow to view the list of the profiles in the system

As you may see, the list contains several columns:

  1. The unique ID of the Profile
  2. Profile Title
  3. Time of the Last Run, when the operation was performed for the last time
  4. Number of Rows in the attached CSV files during the last run
  5. Number of the Errors
  6. Current Status (either enabled or disabled)
  7. Current Activity Status. The values here can be:
    • Idle (before the first run)
    • Pending
    • Running (for the profiles that are working at the moment)
    • Paused
    • Stopped
    • Finished (after the operation has finished)
  8. Data Type. The values can be:
    • Products {links here to be added}
    • Products Extra
    • EAV Structure
    • Categories
    • Sales
  9. Profile Type. The values can be:
    • Import
    • Export

For the sake of convenience, all these columns can be sorted and filtered using the default Magento functionality for managing tables.

Adding New Profile

To add the new profile open System → Rapidflow and click the Add Profile button

Here you can set up your new profile. This user guide covers the configuration of the uRapidFlow Sales extensions so you need to select Sales in the Data Type setting.

Profile Information Tab

Profile Information Box

Title Specify some title here. It will be shown on the Profiles Grid as shown on the screenshot in the previous section of this guide.

Profile Status This setting can be either enabled or disabled. Disabling the profile may be suitable in case you wish to operate some section in future.

Profile Type This can be either Export or Import

Data Type Please specify the data you wish to operate. As this is the manual to the uRapidFlow Sales extension, please select Sales

Please note that after you finish this initial set up and click on the Save or Save And Continue button in the upper-right corner of this page, these settings will not be editable anymore

Store View Please select the desired store view. The first one [admin] Admin refers to the default scope.

File Location In case of the export operation, the file location can be defined in System → Configuration → Advanced → Rapidflow → Default Directories

File Name In case of the export, the file with this name will be generated either in the location from Default Directories section in the extension's configuration or in File Location folder from the previous setting In the case of import, please specify the name of the file that will be imported.

Logging Options Box

Minimum Log Level section consists of 3 separate options with different informational level from the most precise to the most concrete. Let's start with the 3rd option: Errors. This means that only the errors strings will be written to the log file. It is the most concrete solution. In case you have the huge base and many possible problems, this option allows to focus on the biggest problems with Import or Export. The Warnings section puts the Errors and the Warnings as well to the log. The Successful Updates option logs Errors, Warnings, and the successful strings as well, being the most precise log option.

Profile Configuration with JSON Tab

Profile Configuration block

In case you have some Profile, its settings can be loaded by means of the JSON Profile configuration. The profile settings are encoded in the JSON-format as shown on the image.

Managing Profile

Once you click the Save or Save And Continue button in the upper-right corner of the initial Profile set up, you can now edit the profile with far more options and make the fine-tuning. Both Import and Export profiles share the same settings except the tabs Import Options and Upload Files for the Import Profile and Export Options for the Export Profile.

Profile Information Tab

The new settings on this tab are Run Status and Invoke Status. The Run Status section is disabled when you create the import or export profile. You will have the possibility to change the statuses when the operations will begin. As for the Invoke Status, we'll update this guide once this feature will be rolled out. As for now this setting is grayed out

File Options Tab

By default, the Profiles are imported from/exported to the host with your current Magento installation. Yet if you wish to put/take the CSV from some other FTP, you may need to change the default Server Type setting from None to FTP Please check the path to the folder as it should exist and have the permissions enough for the extension to perform the read-write operations.

As you may see, the FTP settings are rather straightforward and in case you face some issues, please contact your hosting company for the details. The setting FTP File Mode may be useful in case you face some issues with the correct line breaking.

Format Options Tab

The recommended File Encoding for the CSV files is the UTF-8, however, in case you need to select something different you can browse through the list of all the possible format options including some exotic as well. Please, bear in mind that in this case, you may face the problem with the illegal characters. Our extension has the special setting, Action to take on illegal character during conversion that allows several workarounds to this case. You can try to transliterate the unknown characters iconv php function is being used or remove them completely. The setting Add warning and path through as original adds this information to the log (in case you've selected Warnings or Successful Updates in the Minimum Log Level setting on the Profile Information tab

The way how your CSV will be created or processed depends on the next three settings:

  1. Field Delimiter The way how the values should be separated. Comma is the default
  2. Field Enclosure Embedded to regard as one value. Quotes are default.
  3. Default Multivalue Separator To show that the field contains several values. Semicolon is a default.

Export Options tab

Export Options block

Stores to Export You can specify the desired store view here. The first one [admin] Admin refers to the default scope with ID 0 (admin area).

Row Types block

You can unfold the Row Types and specify the exact columns that can be exported. Please check this section to check every Row Type and the Columns in question

Export Condition block

This setting allows making conditions by date. The selected row types in the Filter by date range can be exported according to the period of time specified in the Filter Entities From - Filter Entities To settings using the calendar.

Bear in mind that the conditions work only for the selected row types

Import Options tab

Import Options block

Limit Stores to Import You can specify the desired store view here. The first one [admin] Admin refers to the default scope with ID 0 (admin area).

Limit Row Types to Import The field has the multiple select functionality. Press Ctrl and click on the applicable rows you wish to import

Action on Missing Values

When urf_id is missing The URF ID is the UUID that is generated automatically to distinguish the separate entities and to unite the same ones. In case you do the export, they are generated on the fly by means of our extension, however, if the CSV file for the import was created by some third-party extension, this information will be missing. The urf_id field will be populated automatically for these imports as well in case the entity_id field has some values. It is obligatory as from this field the system consider the fields as separate or same. In order to distinguish the same entities names for several e.g. stores, you can specify the prefix that will work as the UUID namespace. For instance, you have 2 Magento shops and though both have the order ID = 1, these are different ones. If the prefix is not specified, they will be handled as the same one. More information about the urf_id can be found in the Fixed Row section later in this manual.

When Store is Missing setting allows handling the situation when the store that is provided in the import file is not presented on the website. 2 options here:

  • Warning: Ignore missing store and use admin. In this case, the extension will add the Warning in the log file (this will be shown if Warnings or Successful Updates setting were selected in the Minimum Log Level settings)
  • Error: Skip row import. In this case, the row will be ignored during the import operation and the information will be added to the log regardless the Minimum Log Level setting.

When Customer is Missing setting allows handling situations when the customer that is provided in the import file is not provided on the website. 3 options here:

  • Warning: Attempt to add customer and skip import if failed. In the case of the problems with customers creation, the special condition allows handling them. If customer create fails:
    1. Warning: Ignore error and set customer to null
    2. Error: Skip row import
  • Warning: Ignore the missing customer and set to null. This option excludes the possibility to add the customer and just populates the data for the missing customers with NULLs.
  • Error: Skip row import

Upload Files

Here you can upload the CSV files for the Import Operation. You can upload several files at the same time. Please specify the desired file for the import on the Profile information tab by defining the File Name. The default location for the uploaded files can be specified in System → Configuration → Advanced → Rapidflow → Default Directories

Profile Status Tab

Here you can find the statistics for your import or export operation and the possibility to view the logs. Export Excel Report button provides the full log. Download Plain Log is the ability to find out the errors and warnings according to your Minimum Log Level setting.

Managing uRapidflow Sales via CRON

Cron job is a very important component of the Magento. CRON is used for running some actions that are performed on schedule. Scheduling is necessary for such operations as emails sending, caching, indexation, regular updates etc. You can add the cron job for managing the uRapidflow Sales profiles.

First of all, create the file that will then be used for cronjob and place it in the root Magento directory.

urapidflow.php
<?php
 
// initialize Magento environment
include_once "app/Mage.php";
Mage::app('admin')->setCurrentStore(0);
 
$helper = Mage::helper('urapidflow');
 
// run profile using ID:
$helper->run(4);
 
// run profile using name. the operations can be performed in batch
$helper->run("Import Sales");

When the setup is done, you'll need to create the cron job and assign it to crontab. The sample of the cronjob is

# daily operations
0 1 * * * /usr/bin/php -f /magento/root/urapidflow.php

You can check this manual in case you are using Debian on your server.

Fixed Rows

Fixed Rows structure

Importing and exporting sales information in the single file requires well-defined information and DB-oriented format. We call it “fixed row format”. Each row begins with row type identifier. For each imported row type there must be a type definition row. This allows combining different types of fixed format rows into the same file, as there's no need for header titles, which means each row's structure is well known and will be expected by the parser. An example of the file with fixed format rows is:

myexample.csv
##GM,customer,sender,recipient,message,urf_id
GM,test@user.com,test2@user.com,test2@user.com,"Lorem ipsum dolor sit amet, ...",df222b37-580b-5220-a57b-f0a9aie8rueu4
 
##SCM,store,adjustment_positive,base_shipping_tax_amount,store_to_order_rate,base_discount_amount,base_to_order_rate,grand_total,base_adjustment_negative,base_subtotal_incl_tax,shipping_amount,subtotal_incl_tax,adjustment_negative,base_shipping_amount,store_to_base_rate,base_to_global_rate,base_adjustment,base_subtotal,discount_amount,subtotal,adjustment,base_grand_total,base_adjustment_positive,base_tax_amount,shipping_tax_amount,tax_amount,order,email_sent,creditmemo_status,state,shipping_address,billing_address,invoice,store_currency_code,order_currency_code,base_currency_code,global_currency_code,transaction_id,increment_id,created_at,updated_at,hidden_tax_amount,base_hidden_tax_amount,shipping_hidden_tax_amount,base_shipping_hidden_tax_amnt,shipping_incl_tax,base_shipping_incl_tax,discount_description,giftcert_amount,base_giftcert_amount,udeliveryest_price,udeliveryest_base_price,last_comment_line,udminamountfee_price,udminamountfee_base_price,mc_giftwrap_amount,mc_giftwrap_base_amount,urf_id
SCM,default,0.0000,0.0000,1.0000,0.0000,1.0000,3.0000,0.0000,13.0000,0.0000,13.0000,0.0000,0.0000,1.0000,1.0000,0.0000,13.0000,0.0000,13.0000,0.0000,3.0000,0.0000,0.0000,0.0000,0.0000,df222b37-580b-5220-a57b-f0a9a75d4c09,,,2,,8b6171a7-c569-501d-bd8d-4d7ddc44c1a4,,USD,USD,USD,USD,,100000001,"2015-02-04 18:36:44","2015-02-04 18:36:44",0.0000,0.0000,,,0.0000,0.0000,,10.0000,10.0000,,,,,,0.0000,0.0000,9207aa40-0137-58cd-a3a9-2733c2cba072

The row types identifiers here are GM (Gift Message) and SCM (Sales Credit Memo). A type definition row begins with ## followed by valid sales type identifier, the order of columns in type definition row determines how matching data rows will be parsed for this exact row type. In the above-mentioned sample the first row

##GM,customer,sender,recipient,message,urf_id

shows at first the name of the row itself and then the columns:

  • the customer email
  • the sender email
  • the recipient email
  • the gift message
  • the unique RapidFlowSales identifier.

Because sales entities do not have natural unique identifiers such as the SKU for products, or email for customers, we have added urf_id which is UUID produced from unique Magento installation UUID and entity database ID. This way when migrating data to another Magento installation, it is guaranteed that if the entity with the same urf_id exists, then it is the same entity imported sometime before.

Fixed Rows types

GM section

GM |Gift Message
#Column NameRequired?
1 Customer
2 Sender
3 Recipient
4 Message
5 Urf Id

Back to the Table

Back to the Top

SBA section

SBA | Sales Billing Agreement
# Column Name Required?
1 Customer
2 Method Code
3 Reference Id
4 Status
5 Created At
6 Updated At
7 Store
8 Agreement Label
9 Urf Id

Back to the Table

Back to the Top

SC section

SCM | Sales Creditmemo
# Column Name Required? # Column Name Required?
1 Store 37 Transaction Id
2 Adjustment Positive 38 Increment Id
3 Base Shipping Tax Amount 39 Created At
4 Store To Order Rate 40 Updated At
5 Base Discount Amount 41 Hidden Tax Amount
6 Base To Order Rate 42 Base Hidden Tax Amount
7 Grand Total 43 Shipping Hidden Tax Amount
8 Base Adjustment Negative 44 Base Shipping Hidden Tax Amnt
9 Base Subtotal Incl Tax 45 Shipping Incl Tax
10 Shipping Amount 46 Base Shipping Incl Tax
11 Subtotal Incl Tax 47 Base Customer Balance Amount
12 Adjustment Negative 48 Customer Balance Amount
13 Base Shipping Amount 49 Bs Customer Bal Total Refunded
14 Store To Base Rate 50 Customer Bal Total Refunded
15 Base To Global Rate 51 Base Gift Cards Amount
16 Base Adjustment 52 Gift Cards Amount
17 Base Subtotal 53 Gw Base Price
18 Discount Amount 54 Gw Price
19 Subtotal 55 Gw Items Base Price
20 Adjustment 56 Gw Items Price
21 Base Grand Total 57 Gw Card Base Price
22 Base Adjustment Positive 58 Gw Card Price
23 Base Tax Amount 59 Gw Base Tax Amount
24 Shipping Tax Amount 60 Gw Tax Amount
25 Tax Amount 61 Gw Items Base Tax Amount
26 Order 62 Gw Items Tax Amount
27 Email Sent 63 Gw Card Base Tax Amount
28 Creditmemo Status 64 Gw Card Tax Amount
29 State 65 Base Reward Currency Amount
30 Shipping Address 66 Reward Currency Amount
31 Billing Address 67 Reward Points Balance
32 Invoice 68 Reward Points Balance Refund
33 Store Currency Code 69 Discount Description
34 Order Currency Code 70 Cybersource Token
35 Base Currency Code 71 Giftcert Amount
36 Global Currency Code 72 Base Giftcert Amount
73 Urf Id

Back to the Table

Back to the Top

SCMC | Sales Creditmemo Comment
# Column Name Required?
1 Creditmemo
2 Is Customer Notified
3 Is Visible On Front
4 Comment
5 Created At
6 Urf Id

Back to the Table

Back to the Top

SCMG | Sales Creditmemo Grid
# Column Name Required?
1 Creditmemo
2 Store
3 Store To Order Rate
4 Base To Order Rate
5 Grand Total
6 Store To Base Rate
7 Base To Global Rate
8 Base Grand Total
9 Order
10 Creditmemo Status
11 State
12 Invoice
13 Store Currency Code
14 Order Currency Code
15 Base Currency Code
16 Global Currency Code
17 Increment Id
18 Order Increment Id
19 Created At
20 Order Created At
21 Billing Name
22 Urf Id

Back to the Table

Back to the Top

SCMI | Sales Creditmemo Item
# Column Name Required? # Column Name Required?
1 Creditmemo 17 Order Item
2 Base Price 18 Additional Data
3 Tax Amount 19 Description
4 Base Row Total 20 Name
5 Discount Amount 21 Hidden Tax Amount
6 Row Total 22 Base Hidden Tax Amount
7 Base Discount Amount 23 Weee Tax Disposition
8 Price Incl Tax 24 Weee Tax Row Disposition
9 Base Tax Amount 25 Base Weee Tax Disposition
10 Base Price Incl Tax 26 Base Weee Tax Row Disposition
11 Qty 27 Weee Tax Applied
12 Base Cost 28 Base Weee Tax Applied Amount
13 Price 29 Base Weee Tax Applied Row Amnt
14 Base Row Total Incl Tax 30 Weee Tax Applied Amount
15 Row Total Incl Tax 31 Weee Tax Applied Row Amount
16 Sku 32 Urf Id

Back to the Table

Back to the Top

SI section

SI | Sales Invoice
# Column Name Required? # Column Name Required?
1 Store 34Created At
2Base Grand Total 35Updated At
3Shipping Tax Amount 36Hidden Tax Amount
4Tax Amount 37Base Hidden Tax Amount
5Base Tax Amount 38Shipping Hidden Tax Amount
6Store To Order Rate 39Base Shipping Hidden Tax Amnt
7Base Shipping Tax Amount 40Shipping Incl Tax
8Base Discount Amount 41Base Shipping Incl Tax
9Base To Order Rate 42Base Total Refunded
10Grand Total 43Base Customer Balance Amount
11Shipping Amount 44Customer Balance Amount
12Subtotal Incl Tax 45Base Gift Cards Amount
13Base Subtotal Incl Tax 46Gift Cards Amount
14Store To Base Rate 47Gw Base Price
15Base Shipping Amount 48Gw Price
16Total Qty 49Gw Items Base Price
17Base To Global Rate 50Gw Items Price
18Subtotal 51Gw Card Base Price
19Base Subtotal 52Gw Card Price
20Discount Amount 53Gw Base Tax Amount
21Billing Address Id 54Gw Tax Amount
22Is Used For Refund 55Gw Items Base Tax Amount
23Order 56Gw Items Tax Amount
24Email Sent 57Gw Card Base Tax Amount
25Can Void Flag 58Gw Card Tax Amount
26State 59Base Reward Currency Amount
27Shipping Address Id 60Reward Currency Amount
28Store Currency Code 61Reward Points Balance
29Transaction Id 62Discount Description
30Order Currency Code 63Cybersource Token
31Base Currency Code 64Giftcert Amount
32Global Currency Code 65Base Giftcert Amount
33Increment Id 66Urf Id

Back to the Table

Back to the Top

SIC | Sales Invoice Comment
# Column Name Required?
1 Invoice
2 Is Customer Notified
3 Is Visible On Front
4 Comment
5 Created At
6 Urf Id

Back to the Table

Back to the Top

SIG | Sales Invoice Grid
# Column Name Required?
1 Invoice
2 Store
3 Base Grand Total
4 Grand Total
5 Order
6 State
7 Store Currency Code
8 Order Currency Code
9 Base Currency Code
10 Global Currency Code
11 Increment Id
12 Order Increment Id
13 Created At
14 Order Created At
15 Billing Name
16 Urf Id

Back to the Table

Back to the Top

SII | Sales Invoice Item
# Column Name Required? # Column Name Required?
1Invoice 17Order Item
2Base Price 18Additional Data
3Tax Amount 19Description
4Base Row Total 20Name
5Discount Amount 21Hidden Tax Amount
6Row Total 22Base Hidden Tax Amount
7Base Discount Amount 23Base Weee Tax Applied Amount
8Price Incl Tax 24Base Weee Tax Applied Row Amnt
9Base Tax Amount 25Weee Tax Applied Amount
10Base Price Incl Tax 26Weee Tax Applied Row Amount
11Qty 27Weee Tax Applied
12Base Cost 28Weee Tax Disposition
13Price 29Weee Tax Row Disposition
14Base Row Total Incl Tax 30Base Weee Tax Disposition
15Row Total Incl Tax 31Base Weee Tax Row Disposition
16Sku 32Urf Id

Back to the Table

Back to the Top

SO section

SO | Sales Order
# Column Name Required? # Column Name Required?
1State 105Global Currency Code
2Status 106Hold Before State
3Coupon Code 107Hold Before Status
4Protect Code 108Order Currency Code
5Shipping Description 109Original Increment Id
6Is Virtual 110Relation Child Id
7Store 111Relation Child Real Id
8Customer 112Relation Parent Id
9Base Discount Amount 113Relation Parent Real Id
10Base Discount Canceled 114Remote Ip
11Base Discount Invoiced 115Shipping Method
12Base Discount Refunded 116Store Currency Code
13Base Grand Total 117Store Name
14Base Shipping Amount 118X Forwarded For
15Base Shipping Canceled 119Customer te
16Base Shipping Invoiced 120Created At
17Base Shipping Refunded 121Updated At
18Base Shipping Tax Amount 122Total Item Count
19Base Shipping Tax Refunded 123Customer Gender
20Base Subtotal 124Hidden Tax Amount
21Base Subtotal Canceled 125Base Hidden Tax Amount
22Base Subtotal Invoiced 126Shipping Hidden Tax Amount
23Base Subtotal Refunded 127Base Shipping Hidden Tax Amnt
24Base Tax Amount 128Hidden Tax Invoiced
25Base Tax Canceled 129Base Hidden Tax Invoiced
26Base Tax Invoiced 130Hidden Tax Refunded
27Base Tax Refunded 131Base Hidden Tax Refunded
28Base To Global Rate 132Shipping Incl Tax
29Base To Order Rate 133Base Shipping Incl Tax
30Base Total Canceled 134Coupon Rule Name
31Base Total Invoiced 135Paypal Ipn Customer tified
32Base Total Invoiced Cost 136Gift Message
33Base Total Offline Refunded 137Base Customer Balance Amount
34Base Total Online Refunded 138Customer Balance Amount
35Base Total Paid 139Base Customer Balance Invoiced
36Base Total Qty Ordered 140Customer Balance Invoiced
37Base Total Refunded 141Base Customer Balance Refunded
38Discount Amount 142Customer Balance Refunded
39Discount Canceled 143Bs Customer Bal Total Refunded
40Discount Invoiced 144Customer Bal Total Refunded
41Discount Refunded 145Gift Cards
42Grand Total 146Base Gift Cards Amount
43Shipping Amount 147Gift Cards Amount
44Shipping Canceled 148Base Gift Cards Invoiced
45Shipping Invoiced 149Gift Cards Invoiced
46Shipping Refunded 150Base Gift Cards Refunded
47Shipping Tax Amount 151Gift Cards Refunded
48Shipping Tax Refunded 152Gw Id
49Store To Base Rate 153Gw Allow Gift Receipt
50Store To Order Rate 154Gw Add Card
51Subtotal 155Gw Base Price
52Subtotal Canceled 156Gw Price
53Subtotal Invoiced 157Gw Items Base Price
54Subtotal Refunded 158Gw Items Price
55Tax Amount 159Gw Card Base Price
56Tax Canceled 160Gw Card Price
57Tax Invoiced 161Gw Base Tax Amount
58Tax Refunded 162Gw Tax Amount
59Total Canceled 163Gw Items Base Tax Amount
60Total Invoiced 164Gw Items Tax Amount
61Total Offline Refunded 165Gw Card Base Tax Amount
62Total Online Refunded 166Gw Card Tax Amount
63Total Paid 167Gw Base Price Invoiced
64Total Qty Ordered 168Gw Price Invoiced
65Total Refunded 169Gw Items Base Price Invoiced
66Can Ship Partially 170Gw Items Price Invoiced
67Can Ship Partially Item 171Gw Card Base Price Invoiced
68Customer Is Guest 172Gw Card Price Invoiced
69Customer te tify 173Gw Base Tax Amount Invoiced
70Billing Address 174Gw Tax Amount Invoiced
71Customer Group 175Gw Items Base Tax Invoiced
72Edit Increment 176Gw Items Tax Invoiced
73Email Sent 177Gw Card Base Tax Invoiced
74Forced Shipment With Invoice 178Gw Card Tax Invoiced
75Payment Auth Expiration 179Gw Base Price Refunded
76Quote Address 180Gw Price Refunded
77Quote 181Gw Items Base Price Refunded
78Shipping Address 182Gw Items Price Refunded
79Adjustment Negative 183Gw Card Base Price Refunded
80Adjustment Positive 184Gw Card Price Refunded
81Base Adjustment Negative 185Gw Base Tax Amount Refunded
82Base Adjustment Positive 186Gw Tax Amount Refunded
83Base Shipping Discount Amount 187Gw Items Base Tax Refunded
84Base Subtotal Incl Tax 188Gw Items Tax Refunded
85Base Total Due 189Gw Card Base Tax Refunded
86Payment Authorization Amount 190Gw Card Tax Refunded
87Shipping Discount Amount 191Reward Points Balance
88Subtotal Incl Tax 192Base Reward Currency Amount
89Total Due 193Reward Currency Amount
90Weight 194Base Rwrd Crrncy Amt Invoiced
91Customer Dob 195Rwrd Currency Amount Invoiced
92Increment Id 196Base Rwrd Crrncy Amnt Refnded
93Applied Rule Ids 197Rwrd Crrncy Amnt Refunded
94Base Currency Code 198Reward Points Balance Refund
95Customer Email 199Reward Points Balance Refunded
96Customer Firstname 200Reward Salesrule Points
97Customer Lastname 201Giftcert Code
98Customer Middlename 202Giftcert Amount
99Customer Prefix 203Base Giftcert Amount
100Customer Suffix 204Giftcert Amount Invoiced
101Customer Taxvat 205Base Giftcert Amount Invoiced
102Discount Description 206Giftcert Amount Credited
103Ext Customer Id 207Base Giftcert Amount Credited
104Ext Order Id 208Giftcert New Gcs
209Urf Id

Back to the Table

Back to the Top

SOA | Sales Order Address
# Column Name Required? # Column Name Required?
1Order 14Country Id
2Customer Address Id 15Firstname
3Quote Address 16Address Type
4Region Id 17Prefix
5Customer 18Middlename
6Fax 19Suffix
7Region 20Company
8Postcode 21Vat Id
9Lastname 22Vat Is Valid
10Street 23Vat Request Id
11City 24Vat Request Date
12Email 25Vat Request Success
13Telephone 26Giftregistry Item Id
27Urf Id

Back to the Table

Back to the Top

SOG | Sales Order Grid
# Column Name Required? # Column Name Required?
1Order 9Total Paid
2Status 10Increment Id
3Store 11Base Currency Code
4Store Name 12Order Currency Code
5Customer 13Shipping Name
6Base Grand Total 14Billing Name
7Base Total Paid 15Created At
8Grand Total 16Updated At
17Urf Id

Back to the Table

Back to the Top

SOI | Sales Order Item
# Column Name Required? # Column Name Required?
1Order 49Ext Order Item Id
2Parent Item 50Locked Do Invoice
3Quote Item 51Locked Do Ship
4Store 52Price Incl Tax
5Created At 53Base Price Incl Tax
6Updated At 54Row Total Incl Tax
7Sku 55Base Row Total Incl Tax
8Product Type 56Hidden Tax Amount
9Product Options 57Base Hidden Tax Amount
10Weight 58Hidden Tax Invoiced
11Is Virtual 59Base Hidden Tax Invoiced
12Name 60Hidden Tax Refunded
13Description 61Base Hidden Tax Refunded
14Applied Rule Ids 62Is minal
15Additional Data 63Tax Canceled
16Free Shipping 64Hidden Tax Canceled
17Is Qty Decimal 65Tax Refunded
18 Discount 66Base Tax Refunded
19Qty Backordered 67Discount Refunded
20Qty Canceled 68Base Discount Refunded
21Qty Invoiced 69Gift Message
22Qty Ordered 70Gift Message Available
23Qty Refunded 71Base Weee Tax Applied Amount
24Qty Shipped 72Base Weee Tax Applied Row Amnt
25Base Cost 73Weee Tax Applied Amount
26Price 74Weee Tax Applied Row Amount
27Base Price 75Weee Tax Applied
28Original Price 76Weee Tax Disposition
29Base Original Price 77Weee Tax Row Disposition
30Tax Percent 78Base Weee Tax Disposition
31Tax Amount 79Base Weee Tax Row Disposition
32Base Tax Amount 80Event Id
33Tax Invoiced 81Giftregistry Item Id
34Base Tax Invoiced 82Gw Id
35Discount Percent 83Gw Base Price
36Discount Amount 84Gw Price
37Base Discount Amount 85Gw Base Tax Amount
38Discount Invoiced 86Gw Tax Amount
39Base Discount Invoiced 87Gw Base Price Invoiced
40Amount Refunded 88Gw Price Invoiced
41Base Amount Refunded 89Gw Base Tax Amount Invoiced
42Row Total 90Gw Tax Amount Invoiced
43Base Row Total 91Gw Base Price Refunded
44Row Invoiced 92Gw Price Refunded
45Base Row Invoiced 93Gw Base Tax Amount Refunded
46Row Weight 94Gw Tax Amount Refunded
47Base Tax Before Discount 95Qty Returned
48Tax Before Discount 96Urf Id

Back to the Table

Back to the Top

SOP | Sales Order Payment
# Column Name Required? # Column Name Required?
1Order 31Cc Status Description
2Base Shipping Captured 32Echeck Type
3Shipping Captured 33Cc Debug Response Serialized
4Amount Refunded 34Cc Ss Start Month
5Base Amount Paid 35Echeck Account Type
6Amount Canceled 36Last Trans Id
7Base Amount Authorized 37Cc Cid Status
8Base Amount Paid Online 38Cc Owner
9Base Amount Refunded Online 39Cc Type
10Base Shipping Amount 40Po Number
11Shipping Amount 41Cc Exp Year
12Amount Paid 42Cc Status
13Amount Authorized 43Echeck Routing Number
14Base Amount Ordered 44Account Status
15Base Shipping Refunded 45Anet Trans Method
16Shipping Refunded 46Cc Debug Response Body
17Base Amount Refunded 47Cc Ss Issue
18Amount Ordered 48Echeck Account Name
19Base Amount Canceled 49Cc Avs Status
20Quote Payment Id 50Cc Number Enc
21Additional Data 51Cc Trans Id
22Cc Exp Month 52Paybox Request Number
23Cc Ss Start Year 53Address Status
24Echeck Bank Name 54Additional Information
25Method 55Cybersource Token
26Cc Debug Request Body 56Flo2cash Account Id
27Cc Secure Verify 57Ideal Issuer Id
28Protection Eligibility 58Ideal Issuer Title
29Cc Approval 59Ideal Transaction Checked
30Cc Last4 59Paybox Question Number
61Urf Id

Back to the Table

Back to the Top

SOSH | Sales Order Status History
# Column Name Required?
1 Order
2 Is Customer tified
3 Is Visible On Front
4 Comment
5 Status
6 Created At
7 Entity Name
8 Urf Id

Back to the Table

Back to the Top

SQ section

SQ | Sales Quote
# Column Name Required? # Column Name Required?
1Store 40Customer Taxvat
2Created At 41Customer Gender
3Updated At 42Subtotal
4Converted At 43Base Subtotal
5Is Active 44Subtotal With Discount
6Is Virtual 45Base Subtotal With Discount
7Is Multi Shipping 46Is Changed
8Items Count 47Trigger Recollect
9Items Qty 48Ext Shipping Info
10Orig Order Id 49Gift Message
11Store To Base Rate 50Is Persistent
12Store To Quote Rate 51Customer Balance Amount Used
13Base Currency Code 52Base Customer Bal Amount Used
14Store Currency Code 53Use Customer Balance
15Quote Currency Code 54Gift Cards
16Grand Total 55Gift Cards Amount
17Base Grand Total 56Base Gift Cards Amount
18Checkout Method 57Gift Cards Amount Used
19Customer 58Base Gift Cards Amount Used
20Customer Tax Class Id 59Gw Id
21Customer Group 60Gw Allow Gift Receipt
22Customer Email 61Gw Add Card
23Customer Prefix 62Gw Base Price
24Customer Firstname 63Gw Price
25Customer Middlename 64Gw Items Base Price
26Customer Lastname 65Gw Items Price
27Customer Suffix 66Gw Card Base Price
28Customer Dob 67Gw Card Price
29Customer te 68Gw Base Tax Amount
30Customer te tify 69Gw Tax Amount
31Customer Is Guest 70Gw Items Base Tax Amount
32Remote Ip 71Gw Items Tax Amount
33Applied Rule Ids 72Gw Card Base Tax Amount
34Reserved Order Id 73Gw Card Tax Amount
35Password Hash 74Use Reward Points
36Coupon Code 75Reward Points Balance
37Global Currency Code 76Base Reward Currency Amount
38Base To Global Rate 77Reward Currency Amount
39Base To Quote Rate 78Giftcert Code
79Urf Id

Back to the Table

Back to the Top

SQA | Sales Quote Address
# Column Name Required? # Column Name Required?
1Quote 47Base Shipping Discount Amount
2Created At 48Subtotal Incl Tax
3Updated At 49Base Subtotal Total Incl Tax
4Customer 50Hidden Tax Amount
5Save In Address Book 51Base Hidden Tax Amount
6Customer Address Id 52Shipping Hidden Tax Amount
7Address Type 53Base Shipping Hidden Tax Amnt
8Email 54Shipping Incl Tax
9Prefix 55Base Shipping Incl Tax
10Firstname 56Vat Id
11Middlename 57Vat Is Valid
12Lastname 58Vat Request Id
13Suffix 59Vat Request Date
14Company 60Vat Request Success
15Street 61Gift Message Id
16City 62Base Customer Balance Amount
17Region 63Customer Balance Amount
18Region Id 64Gift Cards Amount
19Postcode 65Base Gift Cards Amount
20Country Id 66Gift Cards
21Telephone 67Used Gift Cards
22Fax 68Giftregistry Item Id
23Same As Billing 69Gw Id
24Free Shipping 70Gw Allow Gift Receipt
25Collect Shipping Rates 71Gw Add Card
26Shipping Method 72Gw Base Price
27Shipping Description 73Gw Price
28Weight 74Gw Items Base Price
29Subtotal 75Gw Items Price
30Base Subtotal 76Gw Card Base Price
31Subtotal With Discount 77Gw Card Price
32Base Subtotal With Discount 78Gw Base Tax Amount
33Tax Amount 79Gw Tax Amount
34Base Tax Amount 80Gw Items Base Tax Amount
35Shipping Amount 81Gw Items Tax Amount
36Base Shipping Amount 82Gw Card Base Tax Amount
37Shipping Tax Amount 83Gw Card Tax Amount
38Base Shipping Tax Amount 84Reward Points Balance
39Discount Amount 85Base Reward Currency Amount
40Base Discount Amount 86Reward Currency Amount
41Grand Total 87Giftcert Amount
42Base Grand Total 88Base Giftcert Amount
43Customer tes 89Giftcert Code
44Applied Taxes 90Base Giftcert Balances
45Discount Description 91Giftcert Balances
46Shipping Discount Amount 92Urf Id

Back to the Table

Back to the Top

SQAI | Sales Quote Address Item
# Column Name Required? # Column Name Required?
1Parent Item 23Name
2Quote Address 24Description
3Quote Item 25Free Shipping
4Created At 26Is Qty Decimal
5Updated At 27Price
6Applied Rule Ids 28Discount Percent
7Additional Data 29 Discount
8Weight 30Tax Percent
9Qty 31Base Price
10Discount Amount 32Base Cost
11Tax Amount 33Price Incl Tax
12Row Total 34Base Price Incl Tax
13Base Row Total 35Row Total Incl Tax
14Row Total With Discount 36Base Row Total Incl Tax
15Base Discount Amount 37Hidden Tax Amount
16Base Tax Amount 38Base Hidden Tax Amount
17Row Weight 39Gift Message
18Product Id 40Gw Id
19Super Product Id 41Gw Base Price
20Parent Product Id 42Gw Price
21Sku 43Gw Base Tax Amount
22Image 44Gw Tax Amount
45Urf Id

Back to the Table

Back to the Top

SQI | Sales Quote Item
# Column Name Required? # Column Name Required?
1Quote 30Product Type
2Created At 31Base Tax Before Discount
3Updated At 32Tax Before Discount
4Sku 33Original Custom Price
5Store 34Redirect Url
6Parent Item 35Base Cost
7Is Virtual 36Price Incl Tax
8Name 37Base Price Incl Tax
9Description 38Row Total Incl Tax
10Applied Rule Ids 39Base Row Total Incl Tax
11Additional Data 40Hidden Tax Amount
12Free Shipping 41Base Hidden Tax Amount
13Is Qty Decimal 42Gift Message
14Discount 43Weee Tax Disposition
15Weight 44Weee Tax Row Disposition
16Qty 45Base Weee Tax Disposition
17Price 46Base Weee Tax Row Disposition
18Base Price 47Weee Tax Applied
19Custom Price 48Weee Tax Applied Amount
20Discount Percent 49Weee Tax Applied Row Amount
21Discount Amount 50Base Weee Tax Applied Amount
22Base Discount Amount 51Base Weee Tax Applied Row Amnt
23Tax Percent 52Event Id
24Tax Amount 53Giftregistry Item Id
25Base Tax Amount 54Gw Id
26Row Total 55Gw Base Price
27Base Row Total 56Gw Price
28Row Total With Discount 57Gw Base Tax Amount
29Row Weight 58Gw Tax Amount
59Urf Id

Back to the Table

Back to the Top

SQIO | Sales Quote Item Option
# Column Name Required?
1 Item
2 Sku
3 Code
4 Value
5 Urf Id

Back to the Table

Back to the Top

SQP | Sales Quote Payment
# Column Name Required? # Column Name Required?
1 Quote 13 Cc Ss Start Month
2 Created At 14 Cc Ss Start Year
3 Updated At 15 Po Number
4 Method 16 Additional Data
5 Cc Type 17 Cc Ss Issue
6 Cc Number Enc 18 Additional Information
7 Cc Last4 19 Paypal Payer Id
8 Cc Cid Enc 20 Paypal Payer Status
9 Cc Owner 21 Paypal Correlation Id
10 Cc Exp Month 22 Cybersource Token
11 Cc Exp Year 23 Ideal Issuer Id
12 Cc Ss Owner 24 Ideal Issuer List
25 Urf Id

Back to the Table

Back to the Top

SQSR | Sales Quote Shipping Rate
# Column Name Required?
1 Address
2 Created At
3 Updated At
4 Carrier
5 Carrier Title
6 Code
7 Method
8 Method Description
9 Price
10 Error Message
11 Method Title
12 Urf Id

Back to the Table

Back to the Top

SSH section

SSHIP | Sales Shipment
# Column Name Required?
1 Store
2 Total Weight
3 Total Qty
4 Email Sent
5 Order
6 Customer
7 Shipping Address
8 Billing Address
9 Shipment Status
10 Increment Id
11 Created At
12 Updated At
13 Packages
14 Shipping Label
15 Urf Id

Back to the Table

Back to the Top

SSHIPC | Sales Shipment Comment
# Column Name Required?
1Shipment
2Is Customer tified
3Is Visible On Front
4Comment
5Created At
6Urf Id

Back to the Table

Back to the Top

SSHIPG | Sales Shipment Grid
# Column Name Required?
1 Shipment
2 Store
3 Total Qty
4 Order
5 Shipment Status
6 Increment Id
7 Order Increment Id
8 Created At
9 Order Created At
10 Shipping Name
11 Urf Id

Back to the Table

Back to the Top

SSHIPI | Sales Shipment Item
# Column Name Required?
1 Shipment
2 Row Total
3 Price
4 Weight
5 Qty
6 Sku
7 Order Item
8 Additional Data
9 Description
10 Name
11 Urf Id

Back to the Table

Back to the Top

SSHIPT | Sales Shipment Track
# Column Name Required?
1 Shipment
2 Weight
3 Qty
4 Order
5 Track Number
6 Description
7 Title
8 Carrier Code
9 Created At
10 Updated At
11 Urf Id

Back to the Table

Back to the Top

SOT section

SOT | Sales Order Tax
# Column Name Required?
1 Order
2 Code
3 Title
4 Percent
5 Amount
6 Priority
7 Position
8 Base Amount
9 Process
10 Base Real Amount
11 Hidden
12 Urf Id

Back to the Table

Back to the Top

SOTI | Sales Order Tax Item
# Column Name Required?
1 Tax
2 Item
3 Tax Percent
4 Urf Id

Back to the Table

Back to the Top

SPT section

SPT | Sales Payment Transaction
# Column Name Required?
1 Parent
2 Order
3 Payment
4 Txn Id
5 Parent Txn Id
6 Txn Type
7 Is Closed
8 Additional Information
9 Created At
10 Urf Id

Back to the Table

Back to the Top

SRP section

SRP | Sales Recurring Profile
# Column Name Required? # Column Name Required?
1State 17Billing Amount
2Customer 18Trial Period Unit
3Store 19Trial Period Frequency
4Method Code 20Trial Period Max Cycles
5Created At 21Trial Billing Amount
6Updated At 22Currency Code
7Reference Id 23Shipping Amount
8Subscriber Name 24Tax Amount
9Start Datetime 25Init Amount
10Internal Reference Id 26Init May Fail
11Schedule Description 27Order Info
12Suspension Threshold 28Order Item Info
13Bill Failed Later 29Billing Address Info
14Period Unit 30Shipping Address Info
15Period Frequency 31Profile Vendor Info
16Period Max Cycles 32Additional Info

Back to the Table

Back to the Top

Fixed Row CSV Sample

Below is the dummy sample of the CSV file for import

samplefull.csv
##GM,customer,sender,recipient,message,urf_id
GM,test@user.com,jamby77@gmail.com,jamby77@gmail.com,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat   ",someInd
##SCM,store,adjustment_positive,base_shipping_tax_amount,store_to_order_rate,base_discount_amount,base_to_order_rate,grand_total,base_adjustment_negative,base_subtotal_incl_tax,shipping_amount,subtotal_incl_tax,adjustment_negative,base_shipping_amount,store_to_base_rate,base_to_global_rate,base_adjustment,base_subtotal,discount_amount,subtotal,adjustment,base_grand_total,base_adjustment_positive,base_tax_amount,shipping_tax_amount,tax_amount,order,email_sent,creditmemo_status,state,shipping_address,billing_address,invoice,store_currency_code,order_currency_code,base_currency_code,global_currency_code,transaction_id,increment_id,created_at,updated_at,hidden_tax_amount,base_hidden_tax_amount,shipping_hidden_tax_amount,base_shipping_hidden_tax_amnt,shipping_incl_tax,base_shipping_incl_tax,discount_description,giftcert_amount,base_giftcert_amount,udeliveryest_price,udeliveryest_base_price,last_comment_line,udminamountfee_price,udminamountfee_base_price,mc_giftwrap_amount,mc_giftwrap_base_amount,urf_id
SCM,default,0.0000,0.0000,1.0000,0.0000,1.0000,3.0000,0.0000,13.0000,0.0000,13.0000,0.0000,0.0000,1.0000,1.0000,0.0000,13.0000,0.0000,13.0000,0.0000,3.0000,0.0000,0.0000,0.0000,0.0000,df222b37-580b-5220-a57b-f0a9a75d4c09,,,2,,8b6171a7-c569-501d-bd8d-4d7ddc44c1a4,,USD,USD,USD,USD,,100000001,"2015-02-04 18:36:44","2015-02-04 18:36:44",0.0000,0.0000,,,0.0000,0.0000,,10.0000,10.0000,,,,,,0.0000,0.0000,9207aa40-0137-58cd-a3a9-2733c2cba072
SCM,default,0.0000,0.0000,1.0000,0.0000,1.0000,0.0000,0.0000,13.0000,0.0000,13.0000,0.0000,0.0000,1.0000,1.0000,0.0000,13.0000,0.0000,13.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,,,2,,fdf186b2-b67f-5b82-81a4-ef663d11d5d1,,USD,USD,USD,USD,,100000002,"2015-02-04 19:43:41","2015-02-04 19:43:41",0.0000,0.0000,,,0.0000,0.0000,,13.0000,13.0000,,,,,,0.0000,0.0000,d6559648-59ef-5d26-b8ce-5644b2366c37
##SCMG,creditmemo,store,store_to_order_rate,base_to_order_rate,grand_total,store_to_base_rate,base_to_global_rate,base_grand_total,order,creditmemo_status,state,invoice,store_currency_code,order_currency_code,base_currency_code,global_currency_code,increment_id,order_increment_id,created_at,order_created_at,billing_name,urf_id
SCMG,9207aa40-0137-58cd-a3a9-2733c2cba072,default,1.0000,1.0000,3.0000,1.0000,1.0000,3.0000,df222b37-580b-5220-a57b-f0a9a75d4c09,,2,,USD,USD,USD,USD,100000001,100000003,"2015-02-04 18:36:44","2015-02-04 18:00:20","Test User",19316746-e921-5f1f-814c-454add37424f
SCMG,d6559648-59ef-5d26-b8ce-5644b2366c37,default,1.0000,1.0000,0.0000,1.0000,1.0000,0.0000,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,,2,,USD,USD,USD,USD,100000002,100000004,"2015-02-04 19:43:41","2015-02-04 18:47:02","Test User",639f73c5-9cf8-5d02-830a-877a9abfab8b
##SCMI,creditmemo,base_price,tax_amount,base_row_total,discount_amount,row_total,base_discount_amount,price_incl_tax,base_tax_amount,base_price_incl_tax,qty,base_cost,price,base_row_total_incl_tax,row_total_incl_tax,sku,order_item,additional_data,description,name,hidden_tax_amount,base_hidden_tax_amount,weee_tax_disposition,weee_tax_row_disposition,base_weee_tax_disposition,base_weee_tax_row_disposition,weee_tax_applied,base_weee_tax_applied_amount,base_weee_tax_applied_row_amnt,weee_tax_applied_amount,weee_tax_applied_row_amount,mc_giftwrap_amount,mc_giftwrap_base_amount,urf_id
SCMI,9207aa40-0137-58cd-a3a9-2733c2cba072,13.0000,0.0000,13.0000,,13.0000,,13.0000,0.0000,13.0000,1.0000,,13.0000,13.0000,13.0000,Gc1,02e4c2b9-6ec9-5868-925d-6e9c367881c1,,,"Gift Certificate",0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,eb53709e-7781-5914-a03e-980de1132ba0
SCMI,d6559648-59ef-5d26-b8ce-5644b2366c37,13.0000,0.0000,13.0000,,13.0000,,13.0000,0.0000,13.0000,1.0000,,13.0000,13.0000,13.0000,Gc1,bb80510d-1acf-5aa7-bb99-c9a16659797f,,,"Gift Certificate",0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,05cc873f-723c-5180-955f-fce4a80f5696
##SI,store,base_grand_total,shipping_tax_amount,tax_amount,base_tax_amount,store_to_order_rate,base_shipping_tax_amount,base_discount_amount,base_to_order_rate,grand_total,shipping_amount,subtotal_incl_tax,base_subtotal_incl_tax,store_to_base_rate,base_shipping_amount,total_qty,base_to_global_rate,subtotal,base_subtotal,discount_amount,billing_address_id,is_used_for_refund,order,email_sent,can_void_flag,state,shipping_address_id,store_currency_code,transaction_id,order_currency_code,base_currency_code,global_currency_code,increment_id,created_at,updated_at,hidden_tax_amount,base_hidden_tax_amount,shipping_hidden_tax_amount,base_shipping_hidden_tax_amnt,shipping_incl_tax,base_shipping_incl_tax,base_total_refunded,discount_description,giftcert_amount,base_giftcert_amount,udpo_id,shipment,udeliveryest_price,udeliveryest_base_price,last_comment_line,udminamountfee_price,udminamountfee_base_price,mc_giftwrap_amount,mc_giftwrap_base_amount,urf_id
SI,default,13.0000,0.0000,0.0000,0.0000,1.0000,0.0000,0.0000,1.0000,13.0000,0.0000,13.0000,13.0000,1.0000,0.0000,1.0000,1.0000,13.0000,13.0000,0.0000,1,,b9a36932-55f2-5c56-b7a3-975c409dd947,,0,2,,USD,,USD,USD,USD,100000001,"2015-01-15 18:46:52","2015-01-15 18:46:52",0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,,,,,,0.0000,0.0000,029d53a3-db6c-5f18-95cb-adf053907cb6
SI,default,7.0000,0.0000,0.0000,0.0000,1.0000,0.0000,0.0000,1.0000,7.0000,5.0000,12.0000,12.0000,1.0000,5.0000,2.0000,1.0000,12.0000,12.0000,0.0000,2,,d5e1cd30-8833-55df-8ed3-b1ed95cdb17c,,0,2,3,USD,,USD,USD,USD,100000002,"2015-01-16 17:45:41","2015-01-16 17:45:41",0.0000,0.0000,0.0000,,5.0000,5.0000,,,10.0000,10.0000,,,,,,,,0.0000,0.0000,ab7c4939-e85b-5b25-af01-c3dff1d6e812
SI,default,42.0000,0.0000,0.0000,0.0000,1.0000,0.0000,0.0000,1.0000,42.0000,0.0000,52.0000,52.0000,1.0000,0.0000,4.0000,1.0000,52.0000,52.0000,0.0000,4,,df222b37-580b-5220-a57b-f0a9a75d4c09,,0,2,,USD,,USD,USD,USD,100000003,"2015-02-04 18:14:47","2015-02-04 18:14:47",0.0000,0.0000,0.0000,,0.0000,0.0000,,,10.0000,10.0000,,,,,,,,0.0000,0.0000,5aa89752-a237-57a8-9c3a-c04f4a615238
SI,default,10.0000,0.0000,0.0000,0.0000,1.0000,0.0000,0.0000,1.0000,10.0000,0.0000,26.0000,26.0000,1.0000,0.0000,2.0000,1.0000,26.0000,26.0000,0.0000,5,,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,,0,2,,USD,,USD,USD,USD,100000004,"2015-02-04 19:00:28","2015-02-04 19:00:28",0.0000,0.0000,0.0000,,0.0000,0.0000,,,16.0000,16.0000,,,,,,,,0.0000,0.0000,789ee329-6663-5e4e-a203-3085adfe89a7
SI,default,25.9400,0.0000,0.0000,0.0000,0.8717,0.0000,0.0000,0.8717,22.6200,0.0000,22.6200,25.9400,1.0000,0.0000,1.0000,1.0000,22.6200,25.9400,0.0000,6,,db143585-5bf2-5647-8d3f-f860f956e327,,0,2,,USD,,EUR,USD,USD,100000005,"2015-10-28 20:09:19","2015-10-28 20:09:19",0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,,,,,,0.0000,0.0000,36b97159-b33c-5e92-a86a-4ee4d08d664a
##SIG,invoice,store,base_grand_total,grand_total,order,state,store_currency_code,order_currency_code,base_currency_code,global_currency_code,increment_id,order_increment_id,created_at,order_created_at,billing_name,udpo_id,urf_id
SIG,029d53a3-db6c-5f18-95cb-adf053907cb6,default,13.0000,13.0000,b9a36932-55f2-5c56-b7a3-975c409dd947,2,USD,USD,USD,USD,100000001,100000001,"2015-01-15 18:46:52","2015-01-12 14:34:03","Test User",,8af58b4a-bc14-5e30-af82-7b2c7b0a6fcd
SIG,ab7c4939-e85b-5b25-af01-c3dff1d6e812,default,7.0000,7.0000,d5e1cd30-8833-55df-8ed3-b1ed95cdb17c,2,USD,USD,USD,USD,100000002,100000002,"2015-01-16 17:45:41","2015-01-16 17:45:15","Test User",,e1f2b26f-1569-5f16-b88c-3256040e3e10
SIG,5aa89752-a237-57a8-9c3a-c04f4a615238,default,42.0000,42.0000,df222b37-580b-5220-a57b-f0a9a75d4c09,2,USD,USD,USD,USD,100000003,100000003,"2015-02-04 18:14:47","2015-02-04 18:00:20","Test User",,7c63cd53-b8ae-5645-82ba-7dbe438247a4
SIG,789ee329-6663-5e4e-a203-3085adfe89a7,default,10.0000,10.0000,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,2,USD,USD,USD,USD,100000004,100000004,"2015-02-04 19:00:28","2015-02-04 18:47:02","Test User",,e0ef03f3-ee86-52aa-bc3b-d62216bed793
SIG,36b97159-b33c-5e92-a86a-4ee4d08d664a,default,25.9400,22.6200,db143585-5bf2-5647-8d3f-f860f956e327,2,USD,EUR,USD,USD,100000005,100000005,"2015-10-28 20:09:19","2015-10-28 20:08:05","Test  User",,60c2c575-17a5-51af-96b1-1e5d73a3a3a5
##SII,invoice,base_price,tax_amount,base_row_total,discount_amount,row_total,base_discount_amount,price_incl_tax,base_tax_amount,base_price_incl_tax,qty,base_cost,price,base_row_total_incl_tax,row_total_incl_tax,sku,order_item,additional_data,description,name,hidden_tax_amount,base_hidden_tax_amount,base_weee_tax_applied_amount,base_weee_tax_applied_row_amnt,weee_tax_applied_amount,weee_tax_applied_row_amount,weee_tax_applied,weee_tax_disposition,weee_tax_row_disposition,base_weee_tax_disposition,base_weee_tax_row_disposition,udpo_item_id,mc_giftwrap_amount,mc_giftwrap_base_amount,urf_id
SII,029d53a3-db6c-5f18-95cb-adf053907cb6,13.0000,0.0000,13.0000,,13.0000,,13.0000,0.0000,13.0000,1.0000,,13.0000,13.0000,13.0000,Gc1,d65efabb-6deb-576e-b514-125e0db8dd03,,,"Gift Certificate",0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,0.0000,0.0000,0f2651f8-3fa3-546c-9dcd-0b8eb2cf3b61
SII,36b97159-b33c-5e92-a86a-4ee4d08d664a,25.9400,0.0000,25.9400,,22.6200,,22.6200,0.0000,25.9400,1.0000,,22.6119,25.9400,22.6200,Gc1,215c8b43-8556-56e4-9fec-1e7349c2786f,,,"Gift Certificate",0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,0.0000,0.0000,4d9d6464-6a10-5157-aa08-d0ed01a6b770
SII,5aa89752-a237-57a8-9c3a-c04f4a615238,13.0000,0.0000,13.0000,,13.0000,,13.0000,0.0000,13.0000,1.0000,,13.0000,13.0000,13.0000,Gc1,02e4c2b9-6ec9-5868-925d-6e9c367881c1,,,"Gift Certificate",0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,0.0000,0.0000,21f9f5c2-8dcc-5b9a-a51a-07815fda2d4a
SII,5aa89752-a237-57a8-9c3a-c04f4a615238,13.0000,0.0000,39.0000,,39.0000,,13.0000,0.0000,13.0000,3.0000,,13.0000,39.0000,39.0000,Gc1,875b7e95-e856-5386-86eb-712c0bd47082,,,"Gift Certificate",0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,0.0000,0.0000,8f1922a1-8a44-5941-85cb-2879c0576ee7
SII,789ee329-6663-5e4e-a203-3085adfe89a7,13.0000,0.0000,26.0000,,26.0000,,13.0000,0.0000,13.0000,2.0000,,13.0000,26.0000,26.0000,Gc1,bb80510d-1acf-5aa7-bb99-c9a16659797f,,,"Gift Certificate",0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,0.0000,0.0000,bd03f696-aa32-5f24-abe8-2a8038bde395
##SOA,order,customer_address_id,quote_address,region_id,customer,fax,region,postcode,lastname,street,city,email,telephone,country_id,firstname,address_type,prefix,middlename,suffix,company,vat_id,vat_is_valid,vat_request_id,vat_request_date,vat_request_success,urf_id
SOA,080360e3-997f-57cf-b4dd-3cf0d7925c7d,1,,56,test@user.com,,Tennessee,29393,User,"123 test dr",Test,test@user.com,939392010,US,Test,billing,,,,,,,,,,bc312e95-32b8-58ca-8f8f-d2763b9a7ecd
SOA,17396db3-8906-50f3-bad9-ce26940fb54c,1,,56,test@user.com,,Tennessee,29393,User,"123 test dr",Test,test@user.com,939392010,US,Test,billing,,,,,,,,,,5df19e9f-cd7d-50a0-b513-9d0124d3bbf7
SOA,b9a36932-55f2-5c56-b7a3-975c409dd947,1,,56,,,Tennessee,29393,User,"123 test dr",Test,test@user.com,939392010,US,Test,billing,,,,,,,,,,c1bfbb3e-f606-513b-82e1-737986db1bf6
SOA,d5e1cd30-8833-55df-8ed3-b1ed95cdb17c,1,,56,test@user.com,,Tennessee,29393,User,"123 test dr",Test,test@user.com,939392010,US,Test,billing,,,,,,,,,,0129c70a-0112-5dc2-b6a5-aefdc2f4652f
SOA,d5e1cd30-8833-55df-8ed3-b1ed95cdb17c,1,,56,test@user.com,,Tennessee,29393,User,"123 test dr",Test,test@user.com,939392010,US,Test,shipping,,,,,,,,,,6fcc6916-6ead-5e4e-88be-2f446ed9f64f
SOA,db143585-5bf2-5647-8d3f-f860f956e327,1,,56,test@user.com,,Tennessee,29393,User,"123 test dr",Test,test@user.com,939392010,US,Test,billing,,,,,,,,,,6e5bcb8a-a754-55c3-9ab5-b81267cd21a9
SOA,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,1,,56,test@user.com,,Tennessee,29393,User,"123 test dr",Test,test@user.com,939392010,US,Test,billing,,,,,,,,,,fdf186b2-b67f-5b82-81a4-ef663d11d5d1
SOA,df222b37-580b-5220-a57b-f0a9a75d4c09,1,,56,test@user.com,,Tennessee,29393,User,"123 test dr",Test,test@user.com,939392010,US,Test,billing,,,,,,,,,,8b6171a7-c569-501d-bd8d-4d7ddc44c1a4
##SOG,order,status,store,store_name,customer,base_grand_total,base_total_paid,grand_total,total_paid,increment_id,base_currency_code,order_currency_code,shipping_name,billing_name,created_at,updated_at,urf_id
SOG,b9a36932-55f2-5c56-b7a3-975c409dd947,complete,default,"Main Website
Main Website Store
Default Store View",test@user.com,13.0000,13.0000,13.0000,13.0000,100000001,USD,USD," ","Test User","2015-01-12 14:34:03","2015-01-15 18:46:52",4f91411f-6e64-5fa6-93e1-d3b9bdaf4314
SOG,d5e1cd30-8833-55df-8ed3-b1ed95cdb17c,processing,default,"Main Website
Main Website Store
Default Store View",test@user.com,7.0000,17.0000,7.0000,17.0000,100000002,USD,USD,"Test User","Test User","2015-01-16 17:45:15","2015-01-16 17:45:41",89daa0ea-53c4-5b73-84d6-d68973cf2d3c
SOG,df222b37-580b-5220-a57b-f0a9a75d4c09,complete,default,"Main Website
Main Website Store
Default Store View",test@user.com,42.0000,52.0000,42.0000,52.0000,100000003,USD,USD," ","Test User","2015-02-04 18:00:20","2015-02-04 18:36:44",b1b7384b-dcf9-5e7c-b207-5d47a85fa275
SOG,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,complete,default,"Main Website
Main Website Store
Default Store View",test@user.com,10.0000,26.0000,10.0000,26.0000,100000004,USD,USD," ","Test User","2015-02-04 18:47:02","2015-02-04 19:43:41",564d3fcd-57c7-5152-94f5-534d6fd85f0b
SOG,db143585-5bf2-5647-8d3f-f860f956e327,complete,default,"Main Website
Main Website Store
Default Store View",test@user.com,25.9400,25.9400,22.6200,22.6200,100000005,USD,EUR,"  ","Test  User","2015-10-28 20:08:05","2015-10-28 20:09:19",adf46d07-0247-5c4f-b6b4-50cc87fc7f24
SOG,080360e3-997f-57cf-b4dd-3cf0d7925c7d,pending,default,"Main Website
Main Website Store
Default Store View",test@user.com,25.9400,,22.6200,,100000006,USD,EUR,"  ","Test  User","2015-12-01 15:31:39","2015-12-01 15:39:08",fb90b155-e5ed-5f02-9ef4-46fffce33e34
SOG,17396db3-8906-50f3-bad9-ce26940fb54c,pending,default,"Main Website
Main Website Store
Default Store View",test@user.com,14.4700,,12.6200,,100000007,USD,EUR,"  ","Test  User","2015-12-01 15:54:07","2015-12-01 15:55:29",e75517c8-de5d-5023-af07-b541ee79551e
##SOI,order,parent_item,quote_item,store,created_at,updated_at,sku,product_type,product_options,weight,is_virtual,name,description,applied_rule_ids,additional_data,free_shipping,is_qty_decimal,no_discount,qty_backordered,qty_canceled,qty_invoiced,qty_ordered,qty_refunded,qty_shipped,base_cost,price,base_price,original_price,base_original_price,tax_percent,tax_amount,base_tax_amount,tax_invoiced,base_tax_invoiced,discount_percent,discount_amount,base_discount_amount,discount_invoiced,base_discount_invoiced,amount_refunded,base_amount_refunded,row_total,base_row_total,row_invoiced,base_row_invoiced,row_weight,base_tax_before_discount,tax_before_discount,ext_order_item_id,locked_do_invoice,locked_do_ship,price_incl_tax,base_price_incl_tax,row_total_incl_tax,base_row_total_incl_tax,hidden_tax_amount,base_hidden_tax_amount,hidden_tax_invoiced,base_hidden_tax_invoiced,hidden_tax_refunded,base_hidden_tax_refunded,is_nominal,tax_canceled,hidden_tax_canceled,tax_refunded,base_tax_refunded,discount_refunded,base_discount_refunded,gift_message,gift_message_available,base_weee_tax_applied_amount,base_weee_tax_applied_row_amnt,weee_tax_applied_amount,weee_tax_applied_row_amount,weee_tax_applied,weee_tax_disposition,weee_tax_row_disposition,base_weee_tax_disposition,base_weee_tax_row_disposition,udropship_vendor,ud_base_tax_amount,ud_base_hidden_tax_amount,ud_base_discount_amount,ud_base_row_total,ud_row_total,locked_do_udpo,qty_udpo,udpo_seq_number,udpo_qty_reverted,udpo_qty_used,udpo_base_tax_amount,udpo_base_hidden_tax_amount,udpo_base_discount_amount,udpo_base_row_total,udpo_row_total,qty_urma,udsepo_po_type,udsepo_shipment_type,parent_sku,item_line,parent_item_line,mc_giftwrap_amount,mc_giftwrap_base_amount,urf_id
SOI,080360e3-997f-57cf-b4dd-3cf0d7925c7d,,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,default,"2015-12-01 15:31:40","2015-12-01 15:31:40",Gc1,ugiftcert,"a:2:{s:15:""info_buyRequest"";a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""OBehCuLOVPLAKFci"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""20"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:16:""Petar Dzhambazov"";s:15:""recipient_email"";s:17:""jamby77@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:5:""ldldl"";s:7:""send_on"";s:8:""12/21/15"";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}s:7:""options"";a:1:{i:0;a:7:{s:5:""label"";s:3:""s&h"";s:5:""value"";s:5:""check"";s:11:""print_value"";s:5:""check"";s:9:""option_id"";s:1:""1"";s:11:""option_type"";s:5:""radio"";s:12:""option_value"";s:1:""1"";s:11:""custom_view"";b:0;}}}",1.0000,1,"Gift Certificate",,,,0,0,0,,0.0000,0.0000,1.0000,0.0000,0.0000,,22.6119,25.9400,22.6151,25.9437,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,22.6200,25.9400,0.0000,0.0000,1.0000,,,,,,22.6200,25.9400,22.6200,25.9400,0.0000,0.0000,,,,,0,,,,,,,,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,,,,,,,0.0000,,,,,,,,,0.0000,,,,10,,0.0000,0.0000,577152b3-1849-55a0-97cf-1ce65c7f1ff1
SOI,17396db3-8906-50f3-bad9-ce26940fb54c,,cba16cca-1de8-5008-a5a3-dc59ebadece6,default,"2015-12-01 15:54:08","2015-12-01 15:54:08",Gc1,ugiftcert,"a:2:{s:15:""info_buyRequest"";a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""OBehCuLOVPLAKFci"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:16:""Petar Dzhambazov"";s:15:""recipient_email"";s:17:""jamby77@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:0:"""";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}s:7:""options"";a:1:{i:0;a:7:{s:5:""label"";s:3:""s&h"";s:5:""value"";s:5:""check"";s:11:""print_value"";s:5:""check"";s:9:""option_id"";s:1:""1"";s:11:""option_type"";s:5:""radio"";s:12:""option_value"";s:1:""1"";s:11:""custom_view"";b:0;}}}",1.0000,0,"Gift Certificate",,,,0,0,0,,0.0000,0.0000,1.0000,0.0000,0.0000,,12.6135,14.4700,12.6151,14.4718,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,12.6200,14.4700,0.0000,0.0000,1.0000,,,,,,12.6200,14.4700,12.6200,14.4700,0.0000,0.0000,,,,,0,,,,,,,,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,,,,,,,0.0000,,,,,,,,,0.0000,,,,10,,0.0000,0.0000,9ee72fed-79db-5976-9bad-b3a943fcc58a
SOI,b9a36932-55f2-5c56-b7a3-975c409dd947,,ae328bc4-b5e1-54b7-b76e-dc0f62d56270,default,"2015-01-12 14:34:03","2015-01-15 18:46:52",Gc1,ugiftcert,"a:2:{s:15:""info_buyRequest"";a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""jxT8489DJClfi9Ge"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:5:""Petar"";s:15:""recipient_email"";s:17:""jamby77@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:6:""l;ljl;"";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}s:7:""options"";a:1:{i:0;a:7:{s:5:""label"";s:3:""s&h"";s:5:""value"";s:5:""check"";s:11:""print_value"";s:5:""check"";s:9:""option_id"";s:1:""1"";s:11:""option_type"";s:5:""radio"";s:12:""option_value"";s:1:""1"";s:11:""custom_view"";b:0;}}}",1.0000,0,"Gift Certificate",,,,0,0,0,,0.0000,1.0000,1.0000,0.0000,0.0000,,13.0000,13.0000,13.0000,13.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,13.0000,13.0000,13.0000,13.0000,1.0000,,,,,,13.0000,13.0000,13.0000,13.0000,0.0000,0.0000,0.0000,0.0000,,,0,,,,,,,,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,,,,,,,0.0000,,,,,,,,,0.0000,,,,10,,0.0000,0.0000,d65efabb-6deb-576e-b514-125e0db8dd03
SOI,db143585-5bf2-5647-8d3f-f860f956e327,,92000dbf-6eda-5280-83ac-29215d95ed6f,default,"2015-10-28 20:08:05","2015-10-28 20:09:19",Gc1,ugiftcert,"a:2:{s:15:""info_buyRequest"";a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""9MCUvgGc8nsBMUBE"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""20"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:16:""Petar Dzhambazov"";s:15:""recipient_email"";s:17:""jamby77@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:319:""Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat"";s:7:""send_on"";s:12:""Oct 29, 2015"";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}s:7:""options"";a:1:{i:0;a:7:{s:5:""label"";s:3:""s&h"";s:5:""value"";s:5:""check"";s:11:""print_value"";s:5:""check"";s:9:""option_id"";s:1:""1"";s:11:""option_type"";s:5:""radio"";s:12:""option_value"";s:1:""1"";s:11:""custom_view"";b:0;}}}",1.0000,1,"Gift Certificate",,,,0,0,0,,0.0000,1.0000,1.0000,0.0000,0.0000,,22.6119,25.9400,22.6151,25.9437,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,22.6200,25.9400,22.6200,25.9400,1.0000,,,,,,22.6200,25.9400,22.6200,25.9400,0.0000,0.0000,0.0000,0.0000,,,0,,,,,,,,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,,,,,,,0.0000,,,,,,,,,0.0000,,,,10,,0.0000,0.0000,215c8b43-8556-56e4-9fec-1e7349c2786f
SOI,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,,79f2b0c8-e335-5e3b-ab7f-387cecefd701,default,"2015-02-04 18:47:02","2015-02-04 19:43:41",Gc1,ugiftcert,"a:2:{s:15:""info_buyRequest"";a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""HrgLr6XWwNAiGElv"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:2:""me"";s:15:""recipient_email"";s:19:""petar.dev@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:5:""kkljl"";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""2"";}s:7:""options"";a:1:{i:0;a:7:{s:5:""label"";s:3:""s&h"";s:5:""value"";s:5:""check"";s:11:""print_value"";s:5:""check"";s:9:""option_id"";s:1:""1"";s:11:""option_type"";s:5:""radio"";s:12:""option_value"";s:1:""1"";s:11:""custom_view"";b:0;}}}",1.0000,0,"Gift Certificate",,,,0,0,0,,0.0000,2.0000,2.0000,1.0000,0.0000,,13.0000,13.0000,13.0000,13.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,13.0000,13.0000,26.0000,26.0000,26.0000,26.0000,2.0000,,,,,,13.0000,13.0000,26.0000,26.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0,,,0.0000,0.0000,0.0000,0.0000,,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,,,,,,,0.0000,,,,,,,,,0.0000,,,,10,,0.0000,0.0000,bb80510d-1acf-5aa7-bb99-c9a16659797f
SOI,df222b37-580b-5220-a57b-f0a9a75d4c09,,dbe1acc4-42ef-5db2-80a0-e8946df5790d,default,"2015-02-04 18:00:20","2015-02-04 18:36:44",Gc1,ugiftcert,"a:2:{s:15:""info_buyRequest"";a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""BMtYYctWah8AgFGk"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:2:""me"";s:15:""recipient_email"";s:11:""me@mine.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:5:""kdkdk"";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}s:7:""options"";a:1:{i:0;a:7:{s:5:""label"";s:3:""s&h"";s:5:""value"";s:5:""check"";s:11:""print_value"";s:5:""check"";s:9:""option_id"";s:1:""1"";s:11:""option_type"";s:5:""radio"";s:12:""option_value"";s:1:""1"";s:11:""custom_view"";b:0;}}}",1.0000,0,"Gift Certificate",,,,0,0,0,,0.0000,1.0000,1.0000,1.0000,0.0000,,13.0000,13.0000,13.0000,13.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,13.0000,13.0000,13.0000,13.0000,13.0000,13.0000,1.0000,,,,,,13.0000,13.0000,13.0000,13.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0,,,0.0000,0.0000,0.0000,0.0000,,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,,,,,,,0.0000,,,,,,,,,0.0000,,,,10,,0.0000,0.0000,02e4c2b9-6ec9-5868-925d-6e9c367881c1
SOI,df222b37-580b-5220-a57b-f0a9a75d4c09,,593a1c7d-40dc-54fa-b634-0d83c31e3744,default,"2015-02-04 18:00:20","2015-02-04 18:36:44",Gc1,ugiftcert,"a:2:{s:15:""info_buyRequest"";a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""HrgLr6XWwNAiGElv"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:2:""me"";s:15:""recipient_email"";s:19:""petar.dev@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:9:""lkmlk;;lk"";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""3"";}s:7:""options"";a:1:{i:0;a:7:{s:5:""label"";s:3:""s&h"";s:5:""value"";s:5:""check"";s:11:""print_value"";s:5:""check"";s:9:""option_id"";s:1:""1"";s:11:""option_type"";s:5:""radio"";s:12:""option_value"";s:1:""1"";s:11:""custom_view"";b:0;}}}",1.0000,1,"Gift Certificate",,,,0,0,0,,0.0000,3.0000,3.0000,0.0000,0.0000,,13.0000,13.0000,13.0000,13.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,39.0000,39.0000,39.0000,39.0000,3.0000,,,,,,13.0000,13.0000,39.0000,39.0000,0.0000,0.0000,0.0000,0.0000,,,0,,,,,,,,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,0.0000,,,,,,,,0.0000,,,,,,,,,0.0000,,,,20,,0.0000,0.0000,875b7e95-e856-5386-86eb-712c0bd47082
##SOP,order,base_shipping_captured,shipping_captured,amount_refunded,base_amount_paid,amount_canceled,base_amount_authorized,base_amount_paid_online,base_amount_refunded_online,base_shipping_amount,shipping_amount,amount_paid,amount_authorized,base_amount_ordered,base_shipping_refunded,shipping_refunded,base_amount_refunded,amount_ordered,base_amount_canceled,quote_payment_id,additional_data,cc_exp_month,cc_ss_start_year,echeck_bank_name,method,cc_debug_request_body,cc_secure_verify,protection_eligibility,cc_approval,cc_last4,cc_status_description,echeck_type,cc_debug_response_serialized,cc_ss_start_month,echeck_account_type,last_trans_id,cc_cid_status,cc_owner,cc_type,po_number,cc_exp_year,cc_status,echeck_routing_number,account_status,anet_trans_method,cc_debug_response_body,cc_ss_issue,echeck_account_name,cc_avs_status,cc_number_enc,cc_trans_id,paybox_request_number,address_status,additional_information,urf_id
SOP,b9a36932-55f2-5c56-b7a3-975c409dd947,0.0000,0.0000,,13.0000,,,,,0.0000,0.0000,13.0000,,13.0000,,,,13.0000,,,,0,0,,checkmo,,,,,,,,,0,,,,,,,0,,,,,,,,,,,,,,2f291f33-e4ad-5489-977e-47ab46a09e55
SOP,d5e1cd30-8833-55df-8ed3-b1ed95cdb17c,5.0000,5.0000,,7.0000,,,,,5.0000,5.0000,7.0000,,7.0000,,,,7.0000,,,,0,0,,checkmo,,,,,,,,,0,,,,,,,0,,,,,,,,,,,,,,fc669fd1-1cfe-5765-96a2-499ee8442be3
SOP,df222b37-580b-5220-a57b-f0a9a75d4c09,0.0000,0.0000,3.0000,42.0000,,,,,0.0000,0.0000,42.0000,,42.0000,0.0000,0.0000,3.0000,42.0000,,,,0,0,,checkmo,,,,,,,,,0,,,,,,,0,,,,,,,,,,,,,,b2a362b8-23cd-5e7f-af18-9b2d4dd392cf
SOP,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,0.0000,0.0000,0.0000,10.0000,,,,,0.0000,0.0000,10.0000,,10.0000,0.0000,0.0000,0.0000,10.0000,,,,0,0,,checkmo,,,,,,,,,0,,,,,,,0,,,,,,,,,,,,,,7e7d5402-9bd6-534c-887e-d1cf00cd6f40
SOP,db143585-5bf2-5647-8d3f-f860f956e327,0.0000,0.0000,,25.9400,,,,,0.0000,0.0000,22.6200,,25.9400,,,,22.6200,,,,0,0,,checkmo,,,,,,,,,0,,,,,,,0,,,,,,,,,,,,,,8453787d-7460-5d4d-a7a8-3b6f0391749c
SOP,080360e3-997f-57cf-b4dd-3cf0d7925c7d,,,,,,,,,0.0000,0.0000,,,25.9400,,,,22.6200,,,,0,0,,checkmo,,,,,,,,,0,,,,,,,0,,,,,,,,,,,,,,0fe4486c-8a3e-58f7-9421-e7d5c5d1af16
SOP,17396db3-8906-50f3-bad9-ce26940fb54c,,,,,,,,,0.0000,0.0000,,,14.4700,,,,12.6200,,,,0,0,,checkmo,,,,,,,,,0,,,,,,,0,,,,,,,,,,,,,,3fbef5d9-66c2-5df1-83b3-130965fd8bfe
##SOSH,order,is_customer_notified,is_visible_on_front,comment,status,created_at,entity_name,comment_line,urf_id
SOSH,080360e3-997f-57cf-b4dd-3cf0d7925c7d,1,0,,pending,"2015-12-01 15:39:08",order,10,a5562552-03fd-5bd1-a8aa-a17c7d69645e
SOSH,17396db3-8906-50f3-bad9-ce26940fb54c,1,0,,pending,"2015-12-01 15:55:29",order,10,a89cdc6e-2fa7-5dcf-926a-98e537d08d9f
SOSH,b9a36932-55f2-5c56-b7a3-975c409dd947,1,0,,pending,"2015-01-12 14:34:10",order,10,0daedbd6-c3bd-5777-8527-472961203c46
SOSH,b9a36932-55f2-5c56-b7a3-975c409dd947,0,0,,complete,"2015-01-15 18:46:52",invoice,20,712c27bc-2430-5d94-a9e9-883e8b41d025
SOSH,d5e1cd30-8833-55df-8ed3-b1ed95cdb17c,1,0,,pending,"2015-01-16 17:45:15",order,10,39c49175-bcb8-5c40-bcd2-d778744ed1cf
SOSH,d5e1cd30-8833-55df-8ed3-b1ed95cdb17c,0,0,,processing,"2015-01-16 17:45:41",invoice,20,59c952e3-439e-5526-b2e8-5224411e6cb3
SOSH,db143585-5bf2-5647-8d3f-f860f956e327,1,0,,pending,"2015-10-28 20:08:05",order,10,9e8e9790-7782-553a-9d29-c5be09f7fe26
SOSH,db143585-5bf2-5647-8d3f-f860f956e327,0,0,,complete,"2015-10-28 20:09:19",invoice,20,f3448c1f-e140-5cb6-9d1b-c0934446eefa
SOSH,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,1,0,,pending,"2015-02-04 18:47:14",order,10,f091ef66-d035-50e5-9f29-a1147d24a468
SOSH,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,0,0,,complete,"2015-02-04 19:00:28",invoice,20,940588c0-59af-569c-bb7c-d68aac2473af
SOSH,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,2,0,"Refunded amount of $0.00 offline.",processing,"2015-02-04 19:43:41",creditmemo,30,2b650622-9a70-5a88-b809-4852c9a06d42
SOSH,deadb2af-d5d1-5eae-9dec-df6c0bee8e31,0,0,,complete,"2015-02-04 19:43:41",creditmemo,40,b351746d-8335-5509-bde0-a4fad935ba13
SOSH,df222b37-580b-5220-a57b-f0a9a75d4c09,1,0,,pending,"2015-02-04 18:01:24",order,10,2f655de4-7084-5ebe-bae9-f5caa57cabbb
SOSH,df222b37-580b-5220-a57b-f0a9a75d4c09,0,0,,complete,"2015-02-04 18:14:47",invoice,20,0693f246-1bfd-577f-9c9d-ccca591a8b8d
SOSH,df222b37-580b-5220-a57b-f0a9a75d4c09,2,0,"Refunded amount of $3.00 offline.",processing,"2015-02-04 18:36:44",creditmemo,30,cf1f0d2d-7334-5bd1-aa3c-8a49412c0bb1
SOSH,df222b37-580b-5220-a57b-f0a9a75d4c09,0,0,,complete,"2015-02-04 18:36:44",creditmemo,40,6198d5ba-b35c-5cf5-b5d1-b5eeb3ce8d88
##SQ,store,created_at,updated_at,converted_at,is_active,is_virtual,is_multi_shipping,items_count,items_qty,orig_order_id,store_to_base_rate,store_to_quote_rate,base_currency_code,store_currency_code,quote_currency_code,grand_total,base_grand_total,checkout_method,customer,customer_tax_class_id,customer_group,customer_email,customer_prefix,customer_firstname,customer_middlename,customer_lastname,customer_suffix,customer_dob,customer_note,customer_note_notify,customer_is_guest,remote_ip,applied_rule_ids,reserved_order_id,password_hash,coupon_code,global_currency_code,base_to_global_rate,base_to_quote_rate,customer_taxvat,customer_gender,subtotal,base_subtotal,subtotal_with_discount,base_subtotal_with_discount,is_changed,trigger_recollect,ext_shipping_info,gift_message,is_persistent,giftcert_code,udropship_shipping_details,is_udmember,lines_init_flag,urf_id
SQ,default,"2015-01-12 14:32:12","2015-01-12 14:34:11",,0,0,0,1,1.0000,0,1.0000,1.0000,USD,USD,USD,13.0000,13.0000,register,test@user.com,3,General,test@user.com,,Test,,User,,,,1,0,127.0.0.1,,100000001,Mb5ZO19+qWM=,,USD,1.0000,1.0000,,,13.0000,13.0000,13.0000,13.0000,1,0,,,0,,,,,868cd70b-b0bd-595f-9997-89d539a2f7e5
SQ,default,"2015-01-16 17:43:40","2015-01-16 17:45:16",,0,0,0,1,1.0000,0,1.0000,1.0000,USD,USD,USD,7.0000,7.0000,,test@user.com,3,General,test@user.com,,Test,,User,,,,1,0,127.0.0.1,,100000002,,,USD,1.0000,1.0000,,,12.0000,12.0000,12.0000,12.0000,1,0,,,0,EPVMD-D8DSM,,,,96ca5401-6eeb-57f9-80cf-3203929bffd4
SQ,default,"2015-01-21 14:24:13","2015-02-04 18:01:25",,0,0,0,2,4.0000,0,1.0000,1.0000,USD,USD,USD,42.0000,42.0000,,test@user.com,3,General,test@user.com,,Test,,User,,,,1,0,127.0.0.1,,100000003,,,USD,1.0000,1.0000,,,52.0000,52.0000,52.0000,52.0000,1,0,,,0,"AFPYM-R8WCM,",,,,f84d892f-7fb8-5971-9589-aae591141b31
SQ,default,"2015-02-04 18:45:42","2015-02-04 18:47:15",,0,0,0,1,2.0000,0,1.0000,1.0000,USD,USD,USD,10.0000,10.0000,,test@user.com,3,General,test@user.com,,Test,,User,,,,1,0,127.0.0.1,,100000004,,,USD,1.0000,1.0000,,,26.0000,26.0000,26.0000,26.0000,1,0,,,0,AFPYM-R8WCM,,,,7e583752-0381-5c4b-8c26-c19f9eb09398
SQ,default,"2015-06-18 15:14:22","2015-06-18 15:14:24",,1,0,0,1,1.0000,0,1.0000,1.0000,USD,USD,USD,13.0000,13.0000,,,3,"NOT LOGGED IN",,,,,,,,,1,0,127.0.0.1,,,,,USD,1.0000,1.0000,,,13.0000,13.0000,13.0000,13.0000,1,1,,,0,,,,,19c89981-c5fe-5f28-8200-893d179cc78b
SQ,default,"2015-10-06 14:56:42","2015-10-06 14:58:08",,0,0,0,1,1.0000,0,1.0000,1.0000,USD,USD,USD,26.0000,26.0000,,test@user.com,3,General,test@user.com,,Test,,User,,,,1,0,,,,,,USD,1.0000,1.0000,,,22.0000,22.0000,22.0000,22.0000,1,0,,,0,TEST-ADMIN,,,,9a9e2e3a-db2b-51a8-970d-d194637ce76f
SQ,default,"2015-10-06 14:56:44","2015-10-28 20:08:06",,0,0,0,1,1.0000,0,1.0000,0.8717,USD,USD,EUR,22.6200,25.9400,,test@user.com,3,General,test@user.com,,Test,,User,,,,1,0,127.0.0.1,,100000005,,,USD,1.0000,0.8717,,,22.6200,25.9400,22.6200,25.9400,1,0,,,0,,,,,e2628a0f-91d2-5796-b004-9e9ccd5a85e7
SQ,default,"2015-10-29 12:08:19","2015-10-29 12:08:54",,0,0,0,1,1.0000,0,1.0000,0.8717,USD,USD,EUR,61.0100,69.9900,,test@user.com,3,General,test@user.com,,Test,,User,,,,1,0,,,,,,USD,1.0000,0.8717,,,61.0100,69.9900,61.0100,69.9900,1,0,,,0,,,,,17c081ec-6736-5448-852f-2796510f9391
SQ,default,"2015-10-29 12:08:21","2015-12-01 15:40:36",,0,0,0,1,1.0000,0,1.0000,0.8717,USD,USD,EUR,22.6200,25.9400,,test@user.com,3,General,test@user.com,,Test,,User,,,,1,0,127.0.0.1,,100000006,,,USD,1.0000,0.8717,,,22.6200,25.9400,22.6200,25.9400,1,0,,,0,,,,,5643580d-fa2a-551d-868c-772402f0ceb8
SQ,default,"2015-12-01 15:52:35","2015-12-01 15:55:33",,0,0,0,1,1.0000,0,1.0000,0.8717,USD,USD,EUR,12.6200,14.4700,,test@user.com,3,General,test@user.com,,Test,,User,,,,1,0,127.0.0.1,,100000007,,,USD,1.0000,0.8717,,,12.6200,14.4700,12.6200,14.4700,1,0,,,0,,,,,4a942d50-65f0-53c2-84d3-e71cb05f40bd
SQ,default,"2016-01-27 20:32:49","2016-01-27 20:32:49",,1,0,0,0,0.0000,0,1.0000,0.8717,USD,USD,EUR,0.0000,0.0000,,test@user.com,3,General,test@user.com,,Test,,User,,,,1,0,127.0.0.1,,,,,USD,1.0000,0.8717,,,0.0000,0.0000,0.0000,0.0000,1,0,,,0,,,,,adf1fe0d-04cd-5369-81e6-283b1ce5925f
SQ,default,"2016-02-01 23:34:06","2016-02-01 23:39:42",,1,0,0,1,1.0000,0,1.0000,0.8717,USD,USD,EUR,22.6200,25.9500,,,3,"NOT LOGGED IN",,,,,,,,,1,0,127.0.0.1,,,,,USD,1.0000,0.8717,,,32.6200,37.4200,32.6200,37.4200,1,1,,,0,BYNSG-R4GXD,,,,d945d960-b5fa-5d41-a7b7-070fd5e7ecf3
SQ,default,"2016-09-28 16:27:37","2016-09-28 16:27:41",,1,0,0,1,1.0000,0,1.0000,0.8717,USD,USD,EUR,22.6200,25.9400,,,3,"NOT LOGGED IN",,,,,,,,,1,0,127.0.0.1,,,,,USD,1.0000,0.8717,,,22.6200,25.9400,22.6200,25.9400,1,0,,,0,,,,,8c3a02af-b6c6-51c9-ace4-b1aa5fe71d73
SQ,default,"2016-10-17 19:00:34","2016-10-17 19:10:39",,1,0,0,1,1.0000,0,1.0000,0.8717,USD,USD,EUR,12.6200,14.4700,,,3,"NOT LOGGED IN",,,,,,,,,1,0,127.0.0.1,,,,,USD,1.0000,0.8717,,,12.6200,14.4700,12.6200,14.4700,1,0,,,0,,,,,4f467745-5c24-504e-b6a0-03ecfaa6af63
##SQA,quote,created_at,updated_at,customer,save_in_address_book,customer_address_id,address_type,email,prefix,firstname,middlename,lastname,suffix,company,street,city,region,region_id,postcode,country_id,telephone,fax,same_as_billing,free_shipping,collect_shipping_rates,shipping_method,shipping_description,weight,subtotal,base_subtotal,subtotal_with_discount,base_subtotal_with_discount,tax_amount,base_tax_amount,shipping_amount,base_shipping_amount,shipping_tax_amount,base_shipping_tax_amount,discount_amount,base_discount_amount,grand_total,base_grand_total,customer_notes,applied_taxes,discount_description,shipping_discount_amount,base_shipping_discount_amount,subtotal_incl_tax,base_subtotal_total_incl_tax,hidden_tax_amount,base_hidden_tax_amount,shipping_hidden_tax_amount,base_shipping_hidden_tax_amnt,shipping_incl_tax,base_shipping_incl_tax,vat_id,vat_is_valid,vat_request_id,vat_request_date,vat_request_success,gift_message_id,giftcert_amount,base_giftcert_amount,giftcert_code,base_giftcert_balances,giftcert_balances,udropship_shipping_details,udropship_production_details,udropship_production_selection,udeliveryest_price,udeliveryest_base_price,udsplit_custom_rates,udspickup_code,udspickup_title,udspickup_details,udminamountfee_details,udminamountfee_price,udminamountfee_base_price,udminamountfee_price_tax,udminamountfee_base_price_tax,udminamountfee_price_hidden_tax,udminamountfee_base_price_hidden_tax,udminamountfee_price_incl_tax,udminamountfee_base_price_incl_tax,urf_id
SQA,17c081ec-6736-5448-852f-2796510f9391,"2015-10-29 12:08:20","2015-10-29 12:08:54",test@user.com,0,1,billing,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,0,0,0,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,,,0.0000,,,,,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,null,[],,,,,,,,,,,,,,,,,15e2e891-feac-578f-9df7-c42579f412fe
SQA,17c081ec-6736-5448-852f-2796510f9391,"2015-10-29 12:08:20","2015-10-29 12:08:54",test@user.com,0,1,shipping,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,1,0,0,,,70.0000,61.0100,69.9900,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,61.0100,69.9900,,a:0:{},,0.0000,0.0000,61.0100,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,null,"{"""":{""ship_at_date"":""2015-10-30"",""checkout_ship_at_title"":""will ship out October 30, 2015"",""vendor_ship_at_title"":""Must ship by October 30, 2015"",""base_amount"":0,""amount"":0,""delivery_at_date"":"""",""delivery_at_date_to"":"""",""checkout_delivery_at_title"":"""",""vendor_delivery_at_title"":""""}}",,0.0000,0.0000,,,,,[],0.0000,0.0000,,,,,,,6ccd46b9-1301-5229-8a16-bdee7ebc3469
SQA,19c89981-c5fe-5f28-8200-893d179cc78b,"2015-06-18 15:14:22","2015-06-18 15:14:24",,0,,billing,,,,,,,,,,,,,,,,0,0,0,,,0.0000,13.0000,13.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,13.0000,13.0000,,a:0:{},,0.0000,0.0000,13.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,5f1fcee5-0d8f-5361-aabb-d37bc457061a
SQA,19c89981-c5fe-5f28-8200-893d179cc78b,"2015-06-18 15:14:22","2015-06-18 15:14:24",,0,,shipping,,,,,,,,,,,,,,,,1,0,1,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,0.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,6ed0de10-9605-5885-aa7a-88663627b0e6
SQA,4a942d50-65f0-53c2-84d3-e71cb05f40bd,"2015-12-01 15:52:38","2015-12-01 15:54:07",test@user.com,0,1,billing,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,0,0,0,,,0.0000,12.6200,14.4700,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,12.6200,14.4700,,a:0:{},,0.0000,0.0000,12.6200,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,c1faeda5-2a5b-532f-90ee-be2099a533fa
SQA,4a942d50-65f0-53c2-84d3-e71cb05f40bd,"2015-12-01 15:52:38","2015-12-01 15:54:07",test@user.com,0,1,shipping,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,1,0,1,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,0.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,c3740f11-4b5e-51b2-be44-633fb91c2d20
SQA,4f467745-5c24-504e-b6a0-03ecfaa6af63,"2016-10-17 19:00:36","2016-10-17 19:10:39",,0,,billing,,,,,,,,,,,,,,,,0,0,0,,,0.0000,12.6200,14.4700,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,12.6200,14.4700,,a:0:{},,0.0000,0.0000,12.6200,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,11132059-8cf6-5848-93ef-b509a3fd5358
SQA,4f467745-5c24-504e-b6a0-03ecfaa6af63,"2016-10-17 19:00:36","2016-10-17 19:10:39",,0,,shipping,,,,,,,,,,,,,,,,1,0,1,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,0.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,3ee85606-863c-57d0-b19f-d7cf1a237b13
SQA,5643580d-fa2a-551d-868c-772402f0ceb8,"2015-10-29 12:08:21","2015-12-01 15:31:39",test@user.com,0,1,billing,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,0,0,0,,,0.0000,22.6200,25.9400,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,22.6200,25.9400,,a:0:{},,0.0000,0.0000,22.6200,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,4d6cc36d-feff-59b1-91ab-dbe4af7310ce
SQA,5643580d-fa2a-551d-868c-772402f0ceb8,"2015-10-29 12:08:21","2015-12-01 15:31:39",test@user.com,0,1,shipping,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,1,0,0,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,,,0.0000,,,,,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,8fc97b94-314c-5792-88ab-86bf6380dce7
SQA,7e583752-0381-5c4b-8c26-c19f9eb09398,"2015-02-04 18:45:42","2015-02-04 18:47:02",test@user.com,0,1,billing,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,0,0,0,,,0.0000,26.0000,26.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,10.0000,10.0000,,a:0:{},,0.0000,0.0000,26.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,16.0000,16.0000,AFPYM-R8WCM,16,16,,,,,,,,,,,,,,,,,,,778d0f0c-687b-5c90-9ad5-7f5147234eff
SQA,7e583752-0381-5c4b-8c26-c19f9eb09398,"2015-02-04 18:45:42","2015-02-04 18:47:02",test@user.com,0,1,shipping,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,1,0,1,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,0.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,3cff0d42-a920-54f5-89f0-f60151ebd846
SQA,868cd70b-b0bd-595f-9997-89d539a2f7e5,"2015-01-12 14:32:12","2015-01-12 14:34:10",test@user.com,1,1,billing,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,0,0,0,,,0.0000,13.0000,13.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,13.0000,13.0000,,a:0:{},,0.0000,0.0000,13.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,d5b45408-6156-54dc-abdf-c9da53fb9e9d
SQA,868cd70b-b0bd-595f-9997-89d539a2f7e5,"2015-01-12 14:32:12","2015-01-12 14:34:10",test@user.com,0,,shipping,,,,,,,,,,,,,,,,1,0,1,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,0.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,8ea483b3-22c5-50aa-a909-973d553b51d7
SQA,8c3a02af-b6c6-51c9-ace4-b1aa5fe71d73,"2016-09-28 16:27:37","2016-09-28 16:27:41",,0,,billing,,,,,,,,,,,,,,,,0,0,0,,,0.0000,22.6200,25.9400,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,22.6200,25.9400,,a:0:{},,0.0000,0.0000,22.6200,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,416f9b1a-d3ab-579f-b7c8-a0799c0ac11f
SQA,8c3a02af-b6c6-51c9-ace4-b1aa5fe71d73,"2016-09-28 16:27:37","2016-09-28 16:27:41",,0,,shipping,,,,,,,,,,,,,,,,1,0,1,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,0.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,b7d14c93-493b-590e-8060-bd50a2e20a4a
SQA,96ca5401-6eeb-57f9-80cf-3203929bffd4,"2015-01-16 17:44:55","2015-01-16 17:45:15",test@user.com,0,1,billing,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,0,0,0,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,,,0.0000,,,,,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,9ba4513c-629a-52ad-a6af-6266ff75bf22
SQA,96ca5401-6eeb-57f9-80cf-3203929bffd4,"2015-01-16 17:44:55","2015-01-16 17:45:15",test@user.com,0,1,shipping,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,1,0,0,flatrate_flatrate,"Flat Rate - Fixed",1.0000,12.0000,12.0000,0.0000,0.0000,0.0000,0.0000,5.0000,5.0000,0.0000,0.0000,0.0000,0.0000,7.0000,7.0000,,a:0:{},,0.0000,0.0000,12.0000,,0.0000,0.0000,0.0000,,5.0000,5.0000,,,,,,,10.0000,10.0000,EPVMD-D8DSM,10,10,,,,,,,,,,,,,,,,,,,638680e0-ffd6-5ff3-990c-923560640305
SQA,9a9e2e3a-db2b-51a8-970d-d194637ce76f,"2015-10-06 14:56:43","2015-10-06 14:58:08",test@user.com,0,1,billing,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,0,0,0,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,,,0.0000,,,,,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,42ec6ddb-960f-58b3-9cfd-74636bbfa1a1
SQA,9a9e2e3a-db2b-51a8-970d-d194637ce76f,"2015-10-06 14:56:43","2015-10-06 14:58:08",test@user.com,0,1,shipping,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,0,0,0,flatrate_flatrate,"Flat Rate - Fixed",0.0000,22.0000,22.0000,0.0000,0.0000,0.0000,0.0000,5.0000,5.0000,0.0000,0.0000,0.0000,0.0000,26.0000,26.0000,,a:0:{},,0.0000,0.0000,22.0000,,0.0000,0.0000,0.0000,,5.0000,5.0000,,,,,,,1.0000,1.0000,TEST-ADMIN,1,1,,,,,,,,,,,,,,,,,,,dfff6e78-6391-5c48-8aaf-08de002800ab
SQA,adf1fe0d-04cd-5369-81e6-283b1ce5925f,"2016-01-27 20:32:50","2016-01-27 20:32:50",test@user.com,0,,billing,,,,,,,,,,,,,,,,0,0,0,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,,,0.0000,,,,,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,387ecc53-943e-575f-94e2-b0f99e5eea0e
SQA,adf1fe0d-04cd-5369-81e6-283b1ce5925f,"2016-01-27 20:32:50","2016-01-27 20:32:50",test@user.com,0,,shipping,,,,,,,,,,,,,,,,1,0,0,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,,,0.0000,,,,,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,1e1db770-e8fd-5fbd-9198-7f124d5c99c6
SQA,d945d960-b5fa-5d41-a7b7-070fd5e7ecf3,"2016-02-01 23:34:06","2016-02-01 23:39:42",,0,,billing,,,,,,,,,,,,,,,,0,0,0,,,0.0000,32.6200,37.4200,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,22.6200,25.9500,,a:0:{},,0.0000,0.0000,32.6200,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,10.0000,11.4718,BYNSG-R4GXD,11.471836641046,10,,,,,,,,,,,,,,,,,,,2b0ab19a-e353-564f-9baf-e8a35100c2af
SQA,d945d960-b5fa-5d41-a7b7-070fd5e7ecf3,"2016-02-01 23:34:06","2016-02-01 23:39:42",,0,,shipping,,,,,,,,,,,,,,,,1,0,1,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,0.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,77a014ca-2ea6-5849-8a89-def47e1b2621
SQA,e2628a0f-91d2-5796-b004-9e9ccd5a85e7,"2015-10-06 14:56:44","2015-10-28 20:08:05",test@user.com,0,1,billing,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,0,0,0,,,0.0000,22.6200,25.9400,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,22.6200,25.9400,,a:0:{},,0.0000,0.0000,22.6200,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,8741d852-560f-5a06-bc1c-0849dac2973e
SQA,e2628a0f-91d2-5796-b004-9e9ccd5a85e7,"2015-10-06 14:56:44","2015-10-28 20:08:05",test@user.com,0,1,shipping,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,1,0,0,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,,,0.0000,,,,,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,a8cc0883-c60f-58e0-8b63-ec5289a94633
SQA,f84d892f-7fb8-5971-9589-aae591141b31,"2015-01-21 14:24:13","2015-02-04 18:00:20",test@user.com,0,1,billing,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,0,0,0,,,0.0000,52.0000,52.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,42.0000,42.0000,,a:0:{},,0.0000,0.0000,52.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,10.0000,10.0000,AFPYM-R8WCM,10,10,,,,,,,,,,,,,,,,,,,9d2c5b46-54ec-53f1-b0d5-ed39e34a7f91
SQA,f84d892f-7fb8-5971-9589-aae591141b31,"2015-01-21 14:24:13","2015-02-04 18:00:20",test@user.com,0,1,shipping,test@user.com,,Test,,User,,,"123 test dr",Test,Tennessee,56,29393,US,939392010,,1,0,0,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,a:0:{},,0.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,,0.0000,0.0000,,,,,,,0.0000,0.0000,,,,,,,,,,,,,,,,,,,,,,133a61bc-db51-5c88-9f44-f7e2891b7dba
##SQI,quote,created_at,updated_at,sku,store,parent_item,is_virtual,name,description,applied_rule_ids,additional_data,free_shipping,is_qty_decimal,no_discount,weight,qty,price,base_price,custom_price,discount_percent,discount_amount,base_discount_amount,tax_percent,tax_amount,base_tax_amount,row_total,base_row_total,row_total_with_discount,row_weight,product_type,base_tax_before_discount,tax_before_discount,original_custom_price,redirect_url,base_cost,price_incl_tax,base_price_incl_tax,row_total_incl_tax,base_row_total_incl_tax,hidden_tax_amount,base_hidden_tax_amount,gift_message,weee_tax_disposition,weee_tax_row_disposition,base_weee_tax_disposition,base_weee_tax_row_disposition,weee_tax_applied,weee_tax_applied_amount,weee_tax_applied_row_amount,base_weee_tax_applied_amount,base_weee_tax_applied_row_amnt,udropship_vendor,cost,udpo_seq_number,udsepo_po_type,udsepo_shipment_type,parent_sku,item_line,parent_item_line,urf_id
SQI,868cd70b-b0bd-595f-9997-89d539a2f7e5,"2015-01-12 14:32:12","2015-01-12 14:32:12",Gc1,default,,0,"Gift Certificate",,,,0,0,0,1.0000,1.0000,13.0000,13.0000,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,13.0000,13.0000,0.0000,1.0000,ugiftcert,,,,,,13.0000,13.0000,13.0000,13.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,ae328bc4-b5e1-54b7-b76e-dc0f62d56270
SQI,f84d892f-7fb8-5971-9589-aae591141b31,"2015-01-21 14:25:34","2015-01-21 14:25:34",Gc1,default,,0,"Gift Certificate",,,,0,0,0,1.0000,1.0000,13.0000,13.0000,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,13.0000,13.0000,0.0000,1.0000,ugiftcert,,,,,,13.0000,13.0000,13.0000,13.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,dbe1acc4-42ef-5db2-80a0-e8946df5790d
SQI,f84d892f-7fb8-5971-9589-aae591141b31,"2015-02-04 17:57:32","2015-02-04 17:59:14",Gc1,default,,1,"Gift Certificate",,,,0,0,0,1.0000,3.0000,13.0000,13.0000,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,39.0000,39.0000,0.0000,3.0000,ugiftcert,,,,,,13.0000,13.0000,39.0000,39.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,20,,593a1c7d-40dc-54fa-b634-0d83c31e3744
SQI,7e583752-0381-5c4b-8c26-c19f9eb09398,"2015-02-04 18:45:42","2015-02-04 18:45:42",Gc1,default,,0,"Gift Certificate",,,,0,0,0,1.0000,2.0000,13.0000,13.0000,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,26.0000,26.0000,0.0000,2.0000,ugiftcert,,,,,,13.0000,13.0000,26.0000,26.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,79f2b0c8-e335-5e3b-ab7f-387cecefd701
SQI,19c89981-c5fe-5f28-8200-893d179cc78b,"2015-06-18 15:14:23","2015-06-18 15:14:23",Gc1,default,,0,"Gift Certificate",,,,0,0,0,1.0000,1.0000,13.0000,13.0000,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,13.0000,13.0000,0.0000,1.0000,ugiftcert,,,,,,13.0000,13.0000,13.0000,13.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,98d76a3e-6038-5cbf-8379-da1dd413dfdb
SQI,9a9e2e3a-db2b-51a8-970d-d194637ce76f,"2015-10-06 14:57:14","2015-10-06 14:57:28",099446489050,default,,0,"Conf Product",,,,0,0,0,0.0000,1.0000,22.0000,22.0000,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,22.0000,22.0000,0.0000,0.0000,configurable,,,,,,22.0000,22.0000,22.0000,22.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,790219bf-ccae-5899-8fda-61e6afef1795
SQI,9a9e2e3a-db2b-51a8-970d-d194637ce76f,"2015-10-06 14:57:14","2015-10-06 14:57:28",099446126894,default,790219bf-ccae-5899-8fda-61e6afef1795,0,"Conf Product-Small",,,,0,0,0,0.0000,1.0000,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,simple,,,,,,,,,,,,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,cp-1-Small,20,10,c0c927f4-a8af-5b1c-8ed0-0f8bf29fd20b
SQI,e2628a0f-91d2-5796-b004-9e9ccd5a85e7,"2015-10-28 20:04:27","2015-10-28 20:06:05",Gc1,default,,1,"Gift Certificate",,,,0,0,0,1.0000,1.0000,25.9400,25.9400,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,22.6200,25.9400,0.0000,1.0000,ugiftcert,,,,,,22.6200,25.9400,22.6200,25.9400,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,92000dbf-6eda-5280-83ac-29215d95ed6f
SQI,17c081ec-6736-5448-852f-2796510f9391,"2015-10-29 12:08:54","2015-10-29 12:08:54",SSRXL48010101,default,,0,"Kona Wave Rebel XXXL 48 Bodyboard in White Standard Logo-48in",,,,0,0,0,70.0000,1.0000,69.9900,69.9900,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,61.0100,69.9900,0.0000,70.0000,simple,,,,,26.1200,61.0100,69.9900,61.0100,69.9900,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,-1,-1,,10,,3f158965-95a0-5762-be79-66b20c4208f8
SQI,5643580d-fa2a-551d-868c-772402f0ceb8,"2015-12-01 15:27:08","2015-12-01 15:31:09",Gc1,default,,1,"Gift Certificate",,,,0,0,0,1.0000,1.0000,25.9400,25.9400,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,22.6200,25.9400,0.0000,1.0000,ugiftcert,,,,,,22.6200,25.9400,22.6200,25.9400,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,22c1b8ea-cd20-5163-ba7a-eb38d237e57b
SQI,4a942d50-65f0-53c2-84d3-e71cb05f40bd,"2015-12-01 15:52:38","2015-12-01 15:52:38",Gc1,default,,0,"Gift Certificate",,,,0,0,0,1.0000,1.0000,14.4700,14.4700,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,12.6200,14.4700,0.0000,1.0000,ugiftcert,,,,,,12.6200,14.4700,12.6200,14.4700,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,cba16cca-1de8-5008-a5a3-dc59ebadece6
SQI,d945d960-b5fa-5d41-a7b7-070fd5e7ecf3,"2016-02-01 23:34:06","2016-02-01 23:34:06",Gc1,default,,0,"Gift Certificate",,,,0,0,0,1.0000,1.0000,37.4200,37.4200,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,32.6200,37.4200,0.0000,1.0000,ugiftcert,,,,,,32.6200,37.4200,32.6200,37.4200,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,c6e69a7e-641e-5f3e-bd48-f3f46a87285f
SQI,8c3a02af-b6c6-51c9-ace4-b1aa5fe71d73,"2016-09-28 16:27:37","2016-09-28 16:27:37",Gc1,default,,0,"Gift Certificate",,,,0,0,0,1.0000,1.0000,25.9400,25.9400,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,22.6200,25.9400,0.0000,1.0000,ugiftcert,,,,,,22.6200,25.9400,22.6200,25.9400,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,60cae607-5e15-595d-90ce-9517fac12008
SQI,4f467745-5c24-504e-b6a0-03ecfaa6af63,"2016-10-17 19:00:36","2016-10-17 19:00:36",Gc1,default,,0,"Gift Certificate",,,,0,0,0,1.0000,1.0000,14.4700,14.4700,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,12.6200,14.4700,0.0000,1.0000,ugiftcert,,,,,,12.6200,14.4700,12.6200,14.4700,0.0000,0.0000,,0.0000,0.0000,0.0000,0.0000,a:0:{},0.0000,0.0000,0.0000,,,,,,,,10,,e1072c96-cfb9-50f3-a8a6-f706c922c7d3
##SQIO,item,sku,code,value,urf_id
SQIO,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""OBehCuLOVPLAKFci"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""20"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:16:""Petar Dzhambazov"";s:15:""recipient_email"";s:17:""jamby77@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:5:""ldldl"";s:7:""send_on"";s:8:""12/21/15"";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}",2b955202-62d3-529d-b5f5-bbd2f91f35cb
SQIO,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,Gc1,option_ids,1,3d4bdc47-705f-5576-950c-a3ad1af220d4
SQIO,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,Gc1,option_1,1,834490bb-f2df-569f-a9c2-195151b23ea0
SQIO,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,Gc1,amount,22.943673282092,0c21607d-4dc7-54ff-9d6f-f42d878930bb
SQIO,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,Gc1,recipient_name,"Petar Dzhambazov",29f80964-16ed-5d91-a651-22f01e5e534b
SQIO,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,Gc1,recipient_email,jamby77@gmail.com,897f56ee-c3da-5b06-8f58-06a45e7c2fc8
SQIO,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,Gc1,send_on,12/21/15,5a3675e1-5457-54ad-a773-d5c691991c17
SQIO,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,Gc1,delivery_type,virtual,f244e8d2-c767-5040-8a44-dc89e13aac75
SQIO,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,Gc1,recipient_message,ldldl,19d76c6a-e2a4-503d-8f6c-7a0840782331
SQIO,22c1b8ea-cd20-5163-ba7a-eb38d237e57b,Gc1,sender_use_address,1,66d6f714-9891-5259-a4e3-81ddc63a8640
SQIO,3f158965-95a0-5762-be79-66b20c4208f8,SSRXL48010101,info_buyRequest,"a:1:{s:3:""qty"";i:1;}",1dfe64b7-2362-50d0-91c4-fe781158d442
SQIO,593a1c7d-40dc-54fa-b634-0d83c31e3744,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""HrgLr6XWwNAiGElv"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:2:""me"";s:15:""recipient_email"";s:19:""petar.dev@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:9:""lkmlk;;lk"";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""3"";}",74bbe4f6-16b2-5f1a-bbc9-52af15e3ac63
SQIO,593a1c7d-40dc-54fa-b634-0d83c31e3744,Gc1,option_ids,1,5f98c58c-9873-58e7-a472-b74fa4ae501b
SQIO,593a1c7d-40dc-54fa-b634-0d83c31e3744,Gc1,option_1,1,ebcbf0f6-2a3e-5646-bc20-a0fd15dc10aa
SQIO,593a1c7d-40dc-54fa-b634-0d83c31e3744,Gc1,amount,10,4d41c684-9ade-5396-a6c0-87193d4f69e0
SQIO,593a1c7d-40dc-54fa-b634-0d83c31e3744,Gc1,recipient_name,me,962b57e6-d414-5ab8-b5ad-ea64288d9e3d
SQIO,593a1c7d-40dc-54fa-b634-0d83c31e3744,Gc1,recipient_email,petar.dev@gmail.com,fd46129b-a0f9-5687-bb11-a4528b80ce00
SQIO,593a1c7d-40dc-54fa-b634-0d83c31e3744,Gc1,delivery_type,virtual,1054173e-5e40-5f79-bc6a-551673e68d23
SQIO,593a1c7d-40dc-54fa-b634-0d83c31e3744,Gc1,recipient_message,lkmlk;;lk,7f2cd439-0ec7-5407-86ec-412dcfb08cca
SQIO,593a1c7d-40dc-54fa-b634-0d83c31e3744,Gc1,sender_use_address,1,b8d6bd51-7a6d-55f1-91b7-37ef7222a2d3
SQIO,60cae607-5e15-595d-90ce-9517fac12008,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""sk9rvKdfKfvkxkAO"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""20"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:16:""Petar Dzhambazov"";s:15:""recipient_email"";s:17:""jamby77@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:319:""Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat"";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}",4eed8fe3-9db4-599f-8f64-fcff10058bb6
SQIO,60cae607-5e15-595d-90ce-9517fac12008,Gc1,option_ids,1,0bb1a234-ae42-5a9c-9340-4d79065cf9a1
SQIO,60cae607-5e15-595d-90ce-9517fac12008,Gc1,option_1,1,fff4a1e8-4c9e-5ab9-8764-c334e82040c0
SQIO,60cae607-5e15-595d-90ce-9517fac12008,Gc1,amount,22.943673282092,774e15af-20e8-544d-9c1b-e4d322991c5e
SQIO,60cae607-5e15-595d-90ce-9517fac12008,Gc1,recipient_name,"Petar Dzhambazov",893ebce7-b22b-502d-b851-b09994597813
SQIO,60cae607-5e15-595d-90ce-9517fac12008,Gc1,recipient_email,jamby77@gmail.com,77d8390d-9308-5641-8e94-b420a529f3eb
SQIO,60cae607-5e15-595d-90ce-9517fac12008,Gc1,delivery_type,virtual,864bbcfe-3108-5798-be71-a9afb0fbc6fa
SQIO,60cae607-5e15-595d-90ce-9517fac12008,Gc1,recipient_message,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat",dc943c71-2fc6-58ec-bb4c-1eddc6d66816
SQIO,60cae607-5e15-595d-90ce-9517fac12008,Gc1,sender_use_address,1,8d445164-1393-54cd-b460-447c2b5860d3
SQIO,790219bf-ccae-5899-8fda-61e6afef1795,099446489050,info_buyRequest,"a:2:{s:3:""qty"";i:1;s:15:""super_attribute"";a:1:{i:141;s:1:""3"";}}",ccb9c26a-c6d1-5f7f-bc77-b70ddb91368b
SQIO,790219bf-ccae-5899-8fda-61e6afef1795,099446489050,attributes,"a:1:{i:141;s:1:""3"";}",8884c318-7739-5903-b9fa-205c7943411d
SQIO,790219bf-ccae-5899-8fda-61e6afef1795,099446126894,product_qty_5,1,23a89771-b0f3-5529-b22c-9eb654f002b7
SQIO,790219bf-ccae-5899-8fda-61e6afef1795,099446126894,simple_product,5,36b40b33-35fb-59c7-91b8-e83afe914ae2
SQIO,79f2b0c8-e335-5e3b-ab7f-387cecefd701,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""HrgLr6XWwNAiGElv"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:2:""me"";s:15:""recipient_email"";s:19:""petar.dev@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:5:""kkljl"";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""2"";}",872f642d-c823-57b8-891e-da5369067ae7
SQIO,79f2b0c8-e335-5e3b-ab7f-387cecefd701,Gc1,option_ids,1,932a5c30-5ffc-5858-8193-c92f2071ee59
SQIO,79f2b0c8-e335-5e3b-ab7f-387cecefd701,Gc1,option_1,1,14a27433-10c7-51bb-954d-dccafa4c22b4
SQIO,79f2b0c8-e335-5e3b-ab7f-387cecefd701,Gc1,amount,10,4d533701-9120-53c1-b0ef-89f7b32873b2
SQIO,79f2b0c8-e335-5e3b-ab7f-387cecefd701,Gc1,recipient_name,me,5831f846-491a-57cb-9963-718a3d131267
SQIO,79f2b0c8-e335-5e3b-ab7f-387cecefd701,Gc1,recipient_email,petar.dev@gmail.com,dfd1babb-29d8-5821-aa1b-f690582c454e
SQIO,79f2b0c8-e335-5e3b-ab7f-387cecefd701,Gc1,delivery_type,virtual,a4788023-d196-55ab-b127-33536c050d41
SQIO,79f2b0c8-e335-5e3b-ab7f-387cecefd701,Gc1,recipient_message,kkljl,277546d6-c13c-5116-9c6b-bf942405cfa7
SQIO,79f2b0c8-e335-5e3b-ab7f-387cecefd701,Gc1,sender_use_address,1,8ab9f3be-caba-5124-830c-215f6c4504c4
SQIO,92000dbf-6eda-5280-83ac-29215d95ed6f,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""9MCUvgGc8nsBMUBE"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""20"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:16:""Petar Dzhambazov"";s:15:""recipient_email"";s:17:""jamby77@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:319:""Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat"";s:7:""send_on"";s:12:""Oct 29, 2015"";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}",b4be04ec-2d9d-5e10-af3a-fe9fde55be41
SQIO,92000dbf-6eda-5280-83ac-29215d95ed6f,Gc1,option_ids,1,a496f95a-3daf-50d2-8b7e-9dbb36ea4131
SQIO,92000dbf-6eda-5280-83ac-29215d95ed6f,Gc1,option_1,1,5bb275b9-ba18-5465-9964-542e218b3480
SQIO,92000dbf-6eda-5280-83ac-29215d95ed6f,Gc1,amount,22.943673282092,d074b841-86e1-5d0e-ad0a-e9a5d95a3a09
SQIO,92000dbf-6eda-5280-83ac-29215d95ed6f,Gc1,recipient_name,"Petar Dzhambazov",6da3acdc-cd70-568a-bda8-ac9eb5fb2b01
SQIO,92000dbf-6eda-5280-83ac-29215d95ed6f,Gc1,recipient_email,jamby77@gmail.com,192f314d-549f-5015-a96b-caf73039f585
SQIO,92000dbf-6eda-5280-83ac-29215d95ed6f,Gc1,send_on,"Oct 29, 2015",f47bdaa6-92ec-5d5a-8252-ad56c8aea0bb
SQIO,92000dbf-6eda-5280-83ac-29215d95ed6f,Gc1,delivery_type,virtual,6fec08a0-549d-5b38-a10a-5408c62e75a9
SQIO,92000dbf-6eda-5280-83ac-29215d95ed6f,Gc1,recipient_message,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat",483d2c11-6ada-52f1-9422-6bd8866cde53
SQIO,92000dbf-6eda-5280-83ac-29215d95ed6f,Gc1,sender_use_address,1,71b5aa27-20ea-5276-aaf7-bf369da27892
SQIO,98d76a3e-6038-5cbf-8379-da1dd413dfdb,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""HqdGpVO6WDDzEFna"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:2:""me"";s:15:""recipient_email"";s:10:""me@mail.ru"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:4:""msms"";s:7:""send_on"";s:12:""Jun 25, 2015"";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}",ca410b5f-c954-564f-a157-eb8286f51470
SQIO,98d76a3e-6038-5cbf-8379-da1dd413dfdb,Gc1,option_ids,1,49fe786b-fa16-56b9-bfde-f784d7cb3b76
SQIO,98d76a3e-6038-5cbf-8379-da1dd413dfdb,Gc1,option_1,1,a797db3b-8726-5ada-9277-e19cc15b07f6
SQIO,98d76a3e-6038-5cbf-8379-da1dd413dfdb,Gc1,amount,10,bb39ce74-e52c-56cc-a7f4-d975a9fd337f
SQIO,98d76a3e-6038-5cbf-8379-da1dd413dfdb,Gc1,recipient_name,me,16c73765-c551-5933-ad4b-3528f38056f0
SQIO,98d76a3e-6038-5cbf-8379-da1dd413dfdb,Gc1,recipient_email,me@mail.ru,e6d514ef-d1e6-591f-b08c-80eeafe70da9
SQIO,98d76a3e-6038-5cbf-8379-da1dd413dfdb,Gc1,send_on,"Jun 25, 2015",360aa96c-c8db-5c74-8297-3c74bd7faaa3
SQIO,98d76a3e-6038-5cbf-8379-da1dd413dfdb,Gc1,delivery_type,virtual,94a3932c-b119-556d-822b-1852f81c996e
SQIO,98d76a3e-6038-5cbf-8379-da1dd413dfdb,Gc1,recipient_message,msms,c03d81f1-f970-5251-9d5e-da178d8775da
SQIO,98d76a3e-6038-5cbf-8379-da1dd413dfdb,Gc1,sender_use_address,1,302d248e-912a-568c-9244-1326a3b3d51d
SQIO,ae328bc4-b5e1-54b7-b76e-dc0f62d56270,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""jxT8489DJClfi9Ge"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:5:""Petar"";s:15:""recipient_email"";s:17:""jamby77@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:6:""l;ljl;"";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}",8e212f64-1b3c-5d2a-9b36-0bff7c3e53fb
SQIO,ae328bc4-b5e1-54b7-b76e-dc0f62d56270,Gc1,option_ids,1,344b8814-7a18-5000-bd6e-0c4032c7c807
SQIO,ae328bc4-b5e1-54b7-b76e-dc0f62d56270,Gc1,option_1,1,19ff960f-b658-55fe-95a9-5064f6e7308c
SQIO,ae328bc4-b5e1-54b7-b76e-dc0f62d56270,Gc1,amount,10,c73fd018-d7da-5cba-a0f3-9864a09ae5bf
SQIO,ae328bc4-b5e1-54b7-b76e-dc0f62d56270,Gc1,recipient_name,Petar,1233abf7-cbf9-5353-aeaa-d50bb1ab4929
SQIO,ae328bc4-b5e1-54b7-b76e-dc0f62d56270,Gc1,recipient_email,jamby77@gmail.com,30d27502-e965-5538-a655-583f1d6fec31
SQIO,ae328bc4-b5e1-54b7-b76e-dc0f62d56270,Gc1,delivery_type,virtual,31eeb766-6a93-530b-b923-e6c38e9fb9c3
SQIO,ae328bc4-b5e1-54b7-b76e-dc0f62d56270,Gc1,recipient_message,l;ljl;,4e121949-f5ba-5051-8cbb-49f657d04a95
SQIO,ae328bc4-b5e1-54b7-b76e-dc0f62d56270,Gc1,sender_use_address,1,e5765f3d-b0db-5159-803d-30bba96282f5
SQIO,c0c927f4-a8af-5b1c-8ed0-0f8bf29fd20b,099446126894,info_buyRequest,"a:2:{s:3:""qty"";i:1;s:15:""super_attribute"";a:1:{i:141;s:1:""3"";}}",ff443392-ceab-5aef-9a1b-65526213fbd4
SQIO,c0c927f4-a8af-5b1c-8ed0-0f8bf29fd20b,099446126894,parent_product_id,4,ffa7f4c8-a289-5b6d-867f-f36ee51ec157
SQIO,c6e69a7e-641e-5f3e-bd48-f3f46a87285f,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""U5KJE2lDydWWdypY"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""30"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:2:""me"";s:15:""recipient_email"";s:9:""me@me.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:0:"""";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}",b27a9344-0d19-557f-9aeb-8cc2bbd76f39
SQIO,c6e69a7e-641e-5f3e-bd48-f3f46a87285f,Gc1,option_ids,1,70d7d30c-985a-51e9-8507-e6079835cfc3
SQIO,c6e69a7e-641e-5f3e-bd48-f3f46a87285f,Gc1,option_1,1,77294e54-ce29-5261-8ba1-51be6ca5ae33
SQIO,c6e69a7e-641e-5f3e-bd48-f3f46a87285f,Gc1,amount,34.415509923139,33dc6984-4e4a-5f3e-9722-9e881112f76b
SQIO,c6e69a7e-641e-5f3e-bd48-f3f46a87285f,Gc1,recipient_name,me,717f4452-fb8d-586b-80f2-451798f20fcd
SQIO,c6e69a7e-641e-5f3e-bd48-f3f46a87285f,Gc1,recipient_email,me@me.com,5a3ea1e8-ce01-5920-948e-222cd9db2d64
SQIO,c6e69a7e-641e-5f3e-bd48-f3f46a87285f,Gc1,delivery_type,virtual,b1dfd174-ba79-5e7c-8fd4-a64d58340288
SQIO,c6e69a7e-641e-5f3e-bd48-f3f46a87285f,Gc1,sender_use_address,1,2c31b73a-5fbe-5922-b9b9-ec21697ad3d0
SQIO,cba16cca-1de8-5008-a5a3-dc59ebadece6,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""OBehCuLOVPLAKFci"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:16:""Petar Dzhambazov"";s:15:""recipient_email"";s:17:""jamby77@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:0:"""";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}",bf8e53ba-3e4f-504e-b523-0d7ea1a9cbc7
SQIO,cba16cca-1de8-5008-a5a3-dc59ebadece6,Gc1,option_ids,1,60604847-5abb-5d94-8350-fcd816f81685
SQIO,cba16cca-1de8-5008-a5a3-dc59ebadece6,Gc1,option_1,1,e56b09cf-51c5-5e9f-9b3f-c758d24e7bdf
SQIO,cba16cca-1de8-5008-a5a3-dc59ebadece6,Gc1,amount,11.471836641046,91d9d4d4-2466-54cb-a247-5d3d3b9a9b74
SQIO,cba16cca-1de8-5008-a5a3-dc59ebadece6,Gc1,recipient_name,"Petar Dzhambazov",161f4e0d-d46a-5f86-ba92-3152d4418075
SQIO,cba16cca-1de8-5008-a5a3-dc59ebadece6,Gc1,recipient_email,jamby77@gmail.com,81a1d7fa-5ae9-598f-b7af-a9dcda9b4238
SQIO,cba16cca-1de8-5008-a5a3-dc59ebadece6,Gc1,delivery_type,virtual,50b385a1-a258-590a-b0dd-487f17b35d82
SQIO,cba16cca-1de8-5008-a5a3-dc59ebadece6,Gc1,sender_use_address,1,7b25fc25-0ad6-5f90-be81-880c6f91983c
SQIO,dbe1acc4-42ef-5db2-80a0-e8946df5790d,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""BMtYYctWah8AgFGk"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:2:""me"";s:15:""recipient_email"";s:11:""me@mine.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:5:""kdkdk"";s:7:""send_on"";s:0:"""";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}",8a2e87a2-700b-5258-8e3f-d0c668908692
SQIO,dbe1acc4-42ef-5db2-80a0-e8946df5790d,Gc1,option_ids,1,b209ffe2-e35e-5d79-af6e-6628cefb33e1
SQIO,dbe1acc4-42ef-5db2-80a0-e8946df5790d,Gc1,option_1,1,a2f15bcd-2d87-53f7-8c6b-3868c69fa92c
SQIO,dbe1acc4-42ef-5db2-80a0-e8946df5790d,Gc1,amount,10,d816f9d2-e68b-5449-ba50-e9c57705b982
SQIO,dbe1acc4-42ef-5db2-80a0-e8946df5790d,Gc1,recipient_name,me,9e1e1972-a17b-5bd2-aa37-1207f7aed698
SQIO,dbe1acc4-42ef-5db2-80a0-e8946df5790d,Gc1,recipient_email,me@mine.com,4a0218ba-5d99-53bf-9285-630f50a3fa0f
SQIO,dbe1acc4-42ef-5db2-80a0-e8946df5790d,Gc1,delivery_type,virtual,c858d8b2-6ee3-56d3-89b3-64002e3620cc
SQIO,dbe1acc4-42ef-5db2-80a0-e8946df5790d,Gc1,recipient_message,kdkdk,d420bc24-e74e-50a0-8aa5-a0dd67303b9e
SQIO,dbe1acc4-42ef-5db2-80a0-e8946df5790d,Gc1,sender_use_address,1,8db210ea-dff2-58dd-83a4-f9106929b24c
SQIO,e1072c96-cfb9-50f3-a8a6-f706c922c7d3,Gc1,info_buyRequest,"a:15:{s:4:""uenc"";s:80:""aHR0cDovL2xvY2FsLmdjMi5jb20vaW5kZXgucGhwL3NhbXBsZS9naWZ0LWNlcnRpZmljYXRlLmh0bWw,"";s:7:""product"";s:1:""3"";s:8:""form_key"";s:16:""Fr3nnYL4yHE8XO7Q"";s:15:""related_product"";s:0:"""";s:6:""amount"";s:2:""10"";s:14:""email_template"";s:1:""1"";s:12:""pdf_template"";s:1:""1"";s:13:""delivery_type"";s:7:""virtual"";s:14:""recipient_name"";s:16:""Petar Dzhambazov"";s:15:""recipient_email"";s:17:""jamby77@gmail.com"";s:18:""sender_use_address"";s:1:""1"";s:17:""recipient_message"";s:0:"""";s:7:""send_on"";s:12:""Oct 20, 2016"";s:7:""options"";a:1:{i:1;s:1:""1"";}s:3:""qty"";s:1:""1"";}",07125ea6-7108-537c-8ea8-4bef462ea722
SQIO,e1072c96-cfb9-50f3-a8a6-f706c922c7d3,Gc1,option_ids,1,62a125fc-6256-50ed-b01d-1ea60b7a9e91
SQIO,e1072c96-cfb9-50f3-a8a6-f706c922c7d3,Gc1,option_1,1,eec30fcd-9065-5cc9-952f-318d6a9b8bf0
SQIO,e1072c96-cfb9-50f3-a8a6-f706c922c7d3,Gc1,amount,11.471836641046,3a4f985e-42e9-5f62-85a0-043a920e0cd5
SQIO,e1072c96-cfb9-50f3-a8a6-f706c922c7d3,Gc1,recipient_name,"Petar Dzhambazov",481d77eb-68fb-50e1-9e22-e7026748cc8b
SQIO,e1072c96-cfb9-50f3-a8a6-f706c922c7d3,Gc1,recipient_email,jamby77@gmail.com,bd321480-a07f-5df4-813d-2561e68eb6ba
SQIO,e1072c96-cfb9-50f3-a8a6-f706c922c7d3,Gc1,send_on,"Oct 20, 2016",c0f1409b-fe0e-5b6b-81a0-64adfc0ea33e
SQIO,e1072c96-cfb9-50f3-a8a6-f706c922c7d3,Gc1,delivery_type,virtual,d50219d7-e8dd-52a7-b691-3585ea7a97d6
SQIO,e1072c96-cfb9-50f3-a8a6-f706c922c7d3,Gc1,sender_use_address,1,7b8d9255-987e-5c9d-9c88-272dbf1b209e
##SQP,quote,created_at,updated_at,method,cc_type,cc_number_enc,cc_last4,cc_cid_enc,cc_owner,cc_exp_month,cc_exp_year,cc_ss_owner,cc_ss_start_month,cc_ss_start_year,po_number,additional_data,cc_ss_issue,additional_information,paypal_payer_id,paypal_payer_status,paypal_correlation_id,urf_id
SQP,868cd70b-b0bd-595f-9997-89d539a2f7e5,"2015-01-12 14:32:57","2015-01-12 14:34:03",checkmo,,,,,,0,0,,0,0,,,,,,,,4419f333-ef5b-5199-a609-c9da3f711af4
SQP,96ca5401-6eeb-57f9-80cf-3203929bffd4,"2015-01-16 17:44:55","2015-01-16 17:45:15",checkmo,,,,,,0,0,,0,0,,,,,,,,23f03309-e6f5-5667-adb1-75e59bc0ce95
SQP,f84d892f-7fb8-5971-9589-aae591141b31,"2015-02-04 17:59:24","2015-02-04 18:00:20",checkmo,,,,,,0,0,,0,0,,,,,,,,bff60f77-07dd-5f62-bbe9-7bea426dfdc7
SQP,7e583752-0381-5c4b-8c26-c19f9eb09398,"2015-02-04 18:46:41","2015-02-04 18:47:02",checkmo,,,,,,0,0,,0,0,,,,,,,,e39423c4-4943-59a7-8608-44bf4cfc7390
SQP,9a9e2e3a-db2b-51a8-970d-d194637ce76f,"2015-10-06 14:56:43","2015-10-06 14:58:08",checkmo,,,,,,0,0,,0,0,,,,,,,,1eff40ab-3307-502c-a38e-b18a8529ad4b
SQP,e2628a0f-91d2-5796-b004-9e9ccd5a85e7,"2015-10-28 20:06:09","2015-10-28 20:08:05",checkmo,,,,,,0,0,,0,0,,,,,,,,802a570c-2a13-5cf2-ad42-ac3db9282838
SQP,17c081ec-6736-5448-852f-2796510f9391,"2015-10-29 12:08:21","2015-10-29 12:08:54",free,,,,,,0,0,,0,0,,,,,,,,0b92d648-7c1a-5fb9-90a2-f1db9d21b89c
SQP,5643580d-fa2a-551d-868c-772402f0ceb8,"2015-12-01 15:31:12","2015-12-01 15:31:39",checkmo,,,,,,0,0,,0,0,,,,,,,,5af7d91a-63c8-598d-89cd-59bb503bc550
SQP,4a942d50-65f0-53c2-84d3-e71cb05f40bd,"2015-12-01 15:53:00","2015-12-01 15:54:07",checkmo,,,,,,0,0,,0,0,,,,,,,,d7da8c4b-3b28-545e-b0c4-3bc04b820023
##SQSR,address,created_at,updated_at,carrier,carrier_title,code,method,method_description,price,error_message,method_title,udropship_vendor,orig_price,is_custom,urf_id
SQSR,638680e0-ffd6-5ff3-990c-923560640305,"2015-01-16 17:45:10","2015-01-16 17:45:15",flatrate,"Flat Rate",flatrate_flatrate,flatrate,,5.0000,,Fixed,,,,bf39d7db-fd1b-5907-b39e-1bf778af44bc
SQSR,dfff6e78-6391-5c48-8aaf-08de002800ab,"2015-10-06 14:57:44","2015-10-06 14:58:08",flatrate,"Flat Rate",flatrate_flatrate,flatrate,,5.0000,,Fixed,,,,52a7a921-f101-5b7e-ae47-7ef17299a118
##SRP,state,customer,store,method_code,created_at,updated_at,reference_id,subscriber_name,start_datetime,internal_reference_id,schedule_description,suspension_threshold,bill_failed_later,period_unit,period_frequency,period_max_cycles,billing_amount,trial_period_unit,trial_period_frequency,trial_period_max_cycles,trial_billing_amount,currency_code,shipping_amount,tax_amount,init_amount,init_may_fail,order_info,order_item_info,billing_address_info,shipping_address_info,profile_vendor_info,additional_info,urf_id
SRP,1,test@user.com,default,code,"2016-11-04 12:41:11",,kdkdk,"some name","2016-11-04 12:40:23",kjkjk,lkhkljk,0,0,month,1,12,12.0000,week,1,1,0,USD,0.0000,0.0000,0.0000,0,"some info",,,,,,
urfsales/documentation.txt · by unirgy