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. Gift Messages
   2. Billing Agreement
   3. Credit Memo
   4. Orders
   5. Quotes
   6. Shipments
   7. Order Taxation
   8. 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.

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.

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.

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

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.

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.

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.

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.

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

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.

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.

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).

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

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.

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

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

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

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.

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.

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.

Gift Message

Back to the Table

Back to the Top

Sales Billing Agreement

Back to the Table

Back to the Top

Sales Creditmemo

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Sales Invoice

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Sales Order

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Sales Quotes

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Sales Shipping

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Sales Order Tax

Back to the Table

Back to the Top

Back to the Table

Back to the Top

Sales Payments

Back to the Table

Back to the Top

Sales Recurring Profile

Back to the Table

Back to the Top

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",,,,,,