====== uRapidFlow Sales======
===== What is uRapidFlow Sales? =====
The **uRapidFlow Sales** is the Magento extension that allows the user to perform both import and export operations for the Magento [[http://docs.magento.com/m1/ce/user_guide/sales.html|Sales]] section. This may be useful in case you need:
- **import/export** sales data such as
-[[#gm_section|Gift Messages]]
-[[#sba_section|Billing Agreement]]
-[[#sc_section|Credit Memo]]
-[[#so_section|Orders]]
-[[#sq_section|Quotes]]
-[[#ssh_section|Shipments]]
-[[#sot_section|Order Taxation]]
-[[#srp_section|Recurring Profiles]] {afaik, this section in Magento has never worked correctly}
- **add/update** the desired fields;
- **synchronize/migrate** data between Magento installations;
- use [[#file_options_tab|remote location]] **on FTP** to perform such operations;
- use single and batch **scheduling** via [[#managing_urapidflow_sales_via_cron|cron jobs]].
===== Getting Started =====
To handle the import/export operations, the user needs to create **the profiles** for this. These profiles are the configurations that allow the user to perform several activities. Creating separate profiles for separate activities rather than modifying the only profile is a good practice as you may need to perform some operations regularly. After the profile is configured, the user can run them from the list of the Profiles or via [[#managing_urapidflow_sales_via_cron|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
{{ ::d3c7802de3.png?nolink |}}
As you may see, the list contains several columns:
-The unique **ID** of the Profile
- Profile **Title**
- Time of the **Last Run**, when the operation was performed for the last time
- Number of **Rows** in the attached CSV files during the last run
- Number of the **Errors**
- Current **Status** (either enabled or disabled)
- 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)
- **Data Type**. The values can be:
* Products {links here to be added}
* Products Extra
* EAV Structure
* Categories
* Sales
- **Profile Type**. The values can be:
* Import
* Export
For the sake of convenience, all these columns can be sorted and filtered using the default Magento functionality for managing tables.
===== Adding New Profile =====
To add the new profile open **System → Rapidflow** and click the Add Profile button
{{ ::2a3da77cef.png?nolink |}}
{{ :a7f88fc3e5.png?nolink |}}
Here you can set up your new profile. This user guide covers the configuration of the **uRapidFlow Sales** extensions so you need to select **Sales** in the **Data Type** setting.
==== Profile Information Tab ====
=== Profile Information Box ===
{{ ::156698e3a5.png?nolink |}}
**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_options_tab|Export]] or [[#import_options_tab|Import]]
**Data Type** Please specify the data you wish to operate. As this is the manual to the **uRapidFlow Sales** extension, please select Sales
Please note that after you finish this initial set up and click on the Save or Save And Continue button in the upper-right corner of this page, these settings will not be editable anymore
**Store View** Please select the desired store view. The first one [admin] Admin refers to the default scope.
**File Location** In case of the export operation, the file location can be defined in **System → Configuration → Advanced → Rapidflow → Default Directories**
{{ :907f9846f6.png?nolink |}}
**File Name** In case of the export, the file with this name will be generated either in the location from Default Directories section in the extension's configuration or in File Location folder from the previous setting
In the case of import, please specify the name of the file that will be imported.
=== Logging Options Box===
{{ ::6b6f7da09a.png?nolink |}}
**Minimum Log Level** section consists of 3 separate options with different informational level from the most precise to the most concrete.
Let's start with the 3rd option: **Errors**. This means that only the errors strings will be written to the log file. It is the most concrete solution. In case you have the huge base and many possible problems, this option allows to focus on the biggest problems with Import or Export. The **Warnings** section puts the Errors and the Warnings as well to the log. The **Successful Updates** option logs Errors, Warnings, and the successful strings as well, being the most precise log option.
==== Profile Configuration with JSON Tab ====
{{ :urapidflow:c09e67e218.png?nolink |}}
===Profile Configuration block===
In case you have some Profile, its settings can be loaded by means of the JSON Profile configuration. The profile settings are encoded in the JSON-format as shown on the image.
===== Managing Profile =====
Once you click the **Save** or **Save And Continue** button in the upper-right corner of the initial Profile set up, you can now edit the profile with far more options and make the fine-tuning.
Both **Import** and **Export** profiles share the same settings except the tabs [[#import_options_tab|Import Options]] and [[#upload_files|Upload Files]] for the Import Profile and [[#export_options_tab|Export Options]] for the Export Profile.
{{ ::3683664a22.png?nolink |}}
==== Profile Information Tab ====
The new settings on this tab are **Run Status** and **Invoke Status**.
The **Run Status** section is disabled when you create the import or export profile. You will have the possibility to change the statuses when the operations will begin. As for the **Invoke Status**, we'll update this guide once this feature will be rolled out. As for now this setting is grayed out
==== File Options Tab ====
By default, the Profiles are imported from/exported to the host with your current Magento installation. Yet if you wish to put/take the CSV from some other FTP, you may need to change the default **Server Type** setting from None to FTP Please check the path to the folder as it should exist and have the permissions enough for the extension to perform the read-write operations.
{{ ::a71ecd53e3.png?nolink |}}
As you may see, the FTP settings are rather straightforward and in case you face some issues, please contact your hosting company for the details. The setting **FTP File Mode** may be useful in case you face some issues with the correct line breaking.
==== Format Options Tab ====
{{ ::39ea11398f.png?nolink |}}
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 [[http://php.net/manual/en/function.iconv.php|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
{{ ::6b6f7da09a.png?nolink |}}
The way how your CSV will be created or processed depends on the next three settings:
- **Field Delimiter** The way how the values should be separated. Comma is the default
- **Field Enclosure** Embedded to regard as one value. Quotes are default.
- **Default Multivalue Separator** To show that the field contains several values. Semicolon is a default.
==== Export Options tab ====
{{ :urapidflow:1495223053641.png?nolink |}}
=== Export Options block ===
{{ :urapidflow:f344e68fb1.png?nolink |}}
**Stores to Export** You can specify the desired store view here. The first one [admin] Admin refers to the default scope with ID 0 (admin area).
=== Row Types block ===
{{ :urapidflow:047013e95c.png?nolink |}}
You can unfold the Row Types and specify the exact columns that can be exported. Please check [[#fixed_rows|this section]] to check every Row Type and the Columns in question
=== Export Condition block ===
{{ :urapidflow:7e673766b8.png?nolink |}}
This setting allows making conditions by date. The selected row types in the **Filter by date range** can be exported according to the period of time specified in the **Filter Entities From** - **Filter Entities To** settings using the calendar.
Bear in mind that the conditions work only for the selected row types
==== Import Options tab ====
{{ :urapidflow:f1071205f4.png?nolink |}}
=== Import Options block ===
{{ :urapidflow:464c5d9aeb.png?nolink |}}
**Limit Stores to Import** You can specify the desired store view here. The first one [admin] Admin refers to the default scope with ID 0 (admin area).
**Limit Row Types to Import** The field has the multiple select functionality. Press Ctrl and click on the applicable rows you wish to import
=== Action on Missing Values ===
{{ :urapidflow:ab5fc7d80b.png?nolink |}}
**When urf_id is missing** The URF ID is the [[https://en.wikipedia.org/wiki/Universally_uf tnique_identifier|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 [[#fixed_rows| 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**:
- **Warning**: Ignore error and set customer to null
- **Error**: Skip row import
* **Warning**: Ignore the missing customer and set to null. This option excludes the possibility to add the customer and just populates the data for the missing customers with NULLs.
* **Error**: Skip row import
==== Upload Files ====
{{ :urapidflow:1e669ee895.png?nolink |}}
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**
{{ :907f9846f6.png?nolink |}}
===== Profile Status Tab =====
{{ :urapidflow:43e0996def.png?nolink |}}
Here you can find the statistics for your import or export operation and the possibility to view the logs.
**Export Excel Report** button provides the full log.
**Download Plain Log** is the ability to find out the errors and warnings according to your **Minimum Log Level** setting.
===== Managing uRapidflow Sales via CRON =====
Cron job is a very important component of the Magento. CRON is used for running some actions that are performed on schedule. Scheduling is necessary for such operations as emails sending, caching, indexation, regular updates etc. You can add the cron job for managing the **uRapidflow Sales** profiles.
First of all, create the file that will then be used for cronjob and place it in the root Magento directory.
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 [[https://help.ubuntu.com/community/CronHowto#Crontab_Lines|this manual]] in case you are using Debian on your server.
===== Fixed Rows =====
==== Fixed Rows structure====
Importing and exporting sales information in the single file requires well-defined information and DB-oriented format. We call it “**fixed row format**”. Each row begins with **row type identifier**. For each imported row type there must be a **type definition row**.
This allows combining different types of fixed format rows into the same file, as there's no need for header titles, which means each row's structure is well known and will be expected by the parser.
An example of the file with fixed format rows is:
##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|GM (Gift Message)]] and [[#scm_sales_creditmemo|SCM (Sales Credit Memo)]]. A type definition row begins with ## followed by valid sales type identifier, the order of columns in type definition row determines how matching data rows will be parsed for this exact row type. In the above-mentioned sample the first row
##GM,customer,sender,recipient,message,urf_id
shows at first the name of the row itself and then the columns:
* the customer email
* the sender email
* the recipient email
* the gift message
* the unique RapidFlowSales identifier.
Because sales entities do not have natural unique identifiers such as the SKU for products, or email for customers, we have added **urf_id** which is UUID produced from unique Magento installation UUID and entity database ID. This way when migrating data to another Magento installation, it is guaranteed that if the entity with the same urf_id exists, then it is the same entity imported sometime before.
==== Fixed Rows types====
^ Row Type Code ^ Row Type Description ^ ^ Row Type Code ^ Row Type Description ^
| **GM** | [[#gm_gift_message|Gift Message]] | | **SBA** | [[#sba_sales_billing_agreement|Sales Billing Agreement]] |
| **SCM** | [[#scm_sales_creditmemo|Sales Credit Memo]] | | **SCMC** | [[#scmc_sales_creditmemo_comment|Sales Creditmemo Comment]] |
| **SCMG** |[[#scmg_sales_creditmemo_grid|Sales Creditmemo Grid]] | | **SCMI** |[[#scmi_sales_creditmemo_item| Sales Creditmemo Item]] |
| **SI** | [[#si_sales_invoice|Sales Invoice]] | | **SIC** | [[#sic_sales_invoice_comment|Sales Invoice Comment]] |
| **SIG** |[[#sig_sales_invoice_grid|Sales Invoice Grid]] | | **SII** | [[#sii_sales_invoice_item|Sales Invoice Item]] |
| **SO** |[[#so_sales_order| Sales Order]] | | **SOA** | [[#soa_sales_order_address|Sales Order Address]] |
| **SOG** |[[#sog_sales_order_grid| Sales Order Grid]] | | **SOI** | [[#soi_sales_order_item| Sales Order Item]] |
| **SOP** |[[#sop_sales_order_payment|Sales Order Payment]] | | **SOSH** | [[#sosh_sales_order_status_history| Sales Order Status History]] |
| **SQ** |[[#sq_sales_quote| Sales Quote]] | | **SQA** |[[#sqa_sales_quote_address|Sales Quote Address]] |
| **SQAI** |[[#sqai_sales_quote_address_item| Sales Quote Address Item]] | | **SQI** | [[#sqi_sales_quote_item| Sales Quote Item]] |
| **SQIO** |[[#sqio_sales_quote_item_option|Sales Quote Item Option]] | | **SQP** | [[#sqp_sales_quote_payment|Sales Quote Payment]] |
| **SQSR** |[[#sqsr_sales_quote_shipping_rate|Sales Quote Shipping Rate]] | | **SSHIP** | [[#sship_sales_shipment| Sales Shipment ]] |
| **SSHIPC** |[[#sshipc_sales_shipment_comment| Sales Shipment Comment]] | | **SSHIPG** | [[#sshipg_sales_shipment_grid| Sales Shipment Grid ]] |
| **SSHIPI** | [[#sshipi_sales_shipment_item|Sales Shipment Item]] | | **SSHIPT** | [[#sshipt_sales_shipment_track| Sales Shipment Track]] |
| **SOT** | [[#sot_sales_order_tax|Sales Order Tax]] | | **SOTI** | [[#soti_sales_order_tax_item|Sales Order Tax Item]] |
| **SPT** | [[#spt_sales_payment_transaction|Sales Payment Transaction]] | | **SRP** | [[#srp_sales_recurring_profile|Sales Recurring Profile]] |
=== GM section ===
[[http://docs.magento.com/m1/ce/user_guide/marketing/gift-options.html|Gift Message]]
== GM |Gift Message ==
^#^Column Name^Required?^
|1| Customer |
|2| Sender |
|3| Recipient |
|4| Message |
|5| Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
=== SBA section ===
[[http://docs.magento.com/m1/ce/user_guide/payment/paypal-billing-agreements.html|Sales Billing Agreement]]
== SBA | Sales Billing Agreement==
^ # ^ Column Name ^ Required?^
|1| Customer |✔|
|2| Method Code |
|3| Reference Id |
|4| Status |
|5| Created At |
|6| Updated At |
|7| Store |✔|
|8| Agreement Label |
|9| Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
=== SC section ===
[[http://docs.magento.com/m1/ce/user_guide/order-processing/credit-refunds.html|Sales Creditmemo]]
== SCM | Sales Creditmemo ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1| Store |✔| | 37 | Transaction Id |
|2| Adjustment Positive | | | 38 | Increment Id |
|3| Base Shipping Tax Amount | | | 39 | Created At |
|4| Store To Order Rate | | | 40 | Updated At |
|5| Base Discount Amount | | | 41 | Hidden Tax Amount |
|6| Base To Order Rate | | | 42 | Base Hidden Tax Amount |
|7| Grand Total | | | 43 | Shipping Hidden Tax Amount |
|8| Base Adjustment Negative | | | 44 | Base Shipping Hidden Tax Amnt |
|9| Base Subtotal Incl Tax | | | 45 | Shipping Incl Tax |
|10| Shipping Amount | | | 46 | Base Shipping Incl Tax |
|11| Subtotal Incl Tax | | | 47 | Base Customer Balance Amount |
|12| Adjustment Negative | | | 48 | Customer Balance Amount |
|13| Base Shipping Amount | | | 49 | Bs Customer Bal Total Refunded |
|14| Store To Base Rate | | | 50 | Customer Bal Total Refunded |
|15| Base To Global Rate | | | 51 | Base Gift Cards Amount |
|16| Base Adjustment | | | 52 | Gift Cards Amount |
|17| Base Subtotal | | | 53 | Gw Base Price |
|18| Discount Amount | | | 54 | Gw Price |
|19| Subtotal | | | 55 | Gw Items Base Price |
|20| Adjustment | | | 56 | Gw Items Price |
|21| Base Grand Total | | | 57 | Gw Card Base Price |
|22| Base Adjustment Positive | | | 58 | Gw Card Price |
|23| Base Tax Amount | | | 59 | Gw Base Tax Amount |
|24| Shipping Tax Amount | | | 60 | Gw Tax Amount |
|25| Tax Amount | | | 61 | Gw Items Base Tax Amount |
|26| Order |✔| | 62 | Gw Items Tax Amount |
|27| Email Sent | | | 63 | Gw Card Base Tax Amount |
|28| Creditmemo Status | | | 64 | Gw Card Tax Amount |
|29| State | | | 65 | Base Reward Currency Amount |
|30| Shipping Address | | | 66 | Reward Currency Amount |
|31| Billing Address | | | 67 | Reward Points Balance |
|32| Invoice | | | 68 | Reward Points Balance Refund |
|33| Store Currency Code | | | 69 | Discount Description |
|34| Order Currency Code | | | 70 | Cybersource Token |
|35| Base Currency Code | | | 71 | Giftcert Amount |
|36| Global Currency Code | | | 72 | Base Giftcert Amount |
| | | | | 73 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SCMC | Sales Creditmemo Comment ==
^ # ^ Column Name ^ Required?^
| 1 | Creditmemo |✔|
| 2 | Is Customer Notified |
| 3 | Is Visible On Front |
| 4 | Comment |
| 5 | Created At |
| 6 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SCMG | Sales Creditmemo Grid ==
^ # ^ Column Name ^ Required?^
| 1 | Creditmemo |✔|
| 2 | Store |✔|
| 3 | Store To Order Rate |
| 4 | Base To Order Rate |
| 5 | Grand Total |
| 6 | Store To Base Rate |
| 7 | Base To Global Rate |
| 8 | Base Grand Total |
| 9 | Order |
| 10 | Creditmemo Status|
| 11 | State |
| 12 | Invoice |
| 13 | Store Currency Code|
| 14 | Order Currency Code |
| 15 | Base Currency Code |
| 16 | Global Currency Code |
| 17 | Increment Id |
| 18 | Order Increment Id |
| 19 | Created At|
| 20 | Order Created At|
| 21 | Billing Name |
| 22 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SCMI | Sales Creditmemo Item ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1 | Creditmemo |✔| | 17 | Order Item |
|2 | Base Price | | | 18 | Additional Data |
|3 | Tax Amount | | | 19 | Description |
|4 | Base Row Total | | | 20 | Name |
|5 | Discount Amount | | | 21 | Hidden Tax Amount |
|6 | Row Total | | | 22 | Base Hidden Tax Amount |
|7 | Base Discount Amount | | | 23 | Weee Tax Disposition |
|8 | Price Incl Tax | | | 24 | Weee Tax Row Disposition |
|9 | Base Tax Amount | | | 25 | Base Weee Tax Disposition |
|10 | Base Price Incl Tax | | | 26 | Base Weee Tax Row Disposition |
|11 | Qty | | | 27 | Weee Tax Applied |
|12 | Base Cost | | | 28 | Base Weee Tax Applied Amount |
|13 | Price | | | 29 | Base Weee Tax Applied Row Amnt |
|14 | Base Row Total Incl Tax | | | 30 | Weee Tax Applied Amount |
|15 | Row Total Incl Tax | | | 31 | Weee Tax Applied Row Amount |
|16 | Sku | | | 32 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
=== SI section ===
[[http://docs.magento.com/m1/ce/user_guide/order-processing/order-invoice.html|Sales Invoice]]
== SI | Sales Invoice ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1 |Store | | |34|Created At|
|2|Base Grand Total | | |35|Updated At|
|3|Shipping Tax Amount | | |36|Hidden Tax Amount|
|4|Tax Amount | | |37|Base Hidden Tax Amount|
|5|Base Tax Amount | | |38|Shipping Hidden Tax Amount|
|6|Store To Order Rate | | |39|Base Shipping Hidden Tax Amnt|
|7|Base Shipping Tax Amount | | |40|Shipping Incl Tax|
|8|Base Discount Amount | | |41|Base Shipping Incl Tax|
|9|Base To Order Rate | | |42|Base Total Refunded|
|10|Grand Total | | |43|Base Customer Balance Amount|
|11|Shipping Amount | | |44|Customer Balance Amount|
|12|Subtotal Incl Tax | | |45|Base Gift Cards Amount|
|13|Base Subtotal Incl Tax | | |46|Gift Cards Amount|
|14|Store To Base Rate | | |47|Gw Base Price|
|15|Base Shipping Amount | | |48|Gw Price|
|16|Total Qty | | |49|Gw Items Base Price|
|17|Base To Global Rate | | |50|Gw Items Price|
|18|Subtotal | | |51|Gw Card Base Price|
|19|Base Subtotal | | |52|Gw Card Price|
|20|Discount Amount | | |53|Gw Base Tax Amount|
|21|Billing Address Id | | |54|Gw Tax Amount|
|22|Is Used For Refund | | |55|Gw Items Base Tax Amount|
|23|Order |✔| |56|Gw Items Tax Amount|
|24|Email Sent | | |57|Gw Card Base Tax Amount|
|25|Can Void Flag | | |58|Gw Card Tax Amount|
|26|State | | |59|Base Reward Currency Amount|
|27|Shipping Address Id | | |60|Reward Currency Amount|
|28|Store Currency Code | | |61|Reward Points Balance|
|29|Transaction Id | | |62|Discount Description|
|30|Order Currency Code | | |63|Cybersource Token|
|31|Base Currency Code | | |64|Giftcert Amount|
|32|Global Currency Code | | |65|Base Giftcert Amount|
|33|Increment Id | | |66|Urf Id|✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SIC | Sales Invoice Comment ==
^ # ^ Column Name ^ Required?^
| 1 | Invoice |✔|
| 2 | Is Customer Notified |
| 3 | Is Visible On Front |
| 4 | Comment |
| 5 | Created At |
| 6 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SIG | Sales Invoice Grid ==
^ # ^ Column Name ^ Required?^
| 1 | Invoice |✔|
| 2 | Store |
| 3 | Base Grand Total |
| 4 | Grand Total |
| 5 | Order |
| 6 | State |
| 7 | Store Currency Code |
| 8 | Order Currency Code |
| 9 | Base Currency Code |
|10 | Global Currency Code |
|11 | Increment Id |
|12 | Order Increment Id |
|13 | Created At |
|14 | Order Created At |
|15 | Billing Name |
|16 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SII | Sales Invoice Item ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|Invoice |✔| |17|Order Item|
|2|Base Price | | |18|Additional Data|
|3|Tax Amount | | |19|Description|
|4|Base Row Total | | |20|Name|
|5|Discount Amount | | |21|Hidden Tax Amount|
|6|Row Total | | |22|Base Hidden Tax Amount|
|7|Base Discount Amount | | |23|Base Weee Tax Applied Amount|
|8|Price Incl Tax | | |24|Base Weee Tax Applied Row Amnt|
|9|Base Tax Amount | | |25|Weee Tax Applied Amount|
|10|Base Price Incl Tax | | |26|Weee Tax Applied Row Amount|
|11|Qty | | |27|Weee Tax Applied|
|12|Base Cost | | |28|Weee Tax Disposition|
|13|Price | | |29|Weee Tax Row Disposition|
|14|Base Row Total Incl Tax | | |30|Base Weee Tax Disposition|
|15|Row Total Incl Tax | | |31|Base Weee Tax Row Disposition|
|16|Sku | | |32|Urf Id| ✔ |
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
=== SO section===
[[http://docs.magento.com/m1/ce/user_guide/order-processing/order-fulfillment.html|Sales Order]]
== SO | Sales Order ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|State | | |105|Global Currency Code|
|2|Status | | |106|Hold Before State|
|3|Coupon Code | | |107|Hold Before Status|
|4|Protect Code | | |108|Order Currency Code|
|5|Shipping Description | | |109|Original Increment Id|
|6|Is Virtual | | |110|Relation Child Id|
|7|Store | | |111|Relation Child Real Id|
|8|Customer | | |112|Relation Parent Id|
|9|Base Discount Amount | | |113|Relation Parent Real Id|
|10|Base Discount Canceled | | |114|Remote Ip|
|11|Base Discount Invoiced | | |115|Shipping Method|
|12|Base Discount Refunded | | |116|Store Currency Code|
|13|Base Grand Total | | |117|Store Name|
|14|Base Shipping Amount | | |118|X Forwarded For|
|15|Base Shipping Canceled | | |119|Customer te|
|16|Base Shipping Invoiced | | |120|Created At|
|17|Base Shipping Refunded | | |121|Updated At|
|18|Base Shipping Tax Amount | | |122|Total Item Count|
|19|Base Shipping Tax Refunded | | |123|Customer Gender|
|20|Base Subtotal | | |124|Hidden Tax Amount|
|21|Base Subtotal Canceled | | |125|Base Hidden Tax Amount|
|22|Base Subtotal Invoiced | | |126|Shipping Hidden Tax Amount|
|23|Base Subtotal Refunded | | |127|Base Shipping Hidden Tax Amnt|
|24|Base Tax Amount | | |128|Hidden Tax Invoiced|
|25|Base Tax Canceled | | |129|Base Hidden Tax Invoiced|
|26|Base Tax Invoiced | | |130|Hidden Tax Refunded|
|27|Base Tax Refunded | | |131|Base Hidden Tax Refunded|
|28|Base To Global Rate | | |132|Shipping Incl Tax|
|29|Base To Order Rate | | |133|Base Shipping Incl Tax|
|30|Base Total Canceled | | |134|Coupon Rule Name|
|31|Base Total Invoiced | | |135|Paypal Ipn Customer tified|
|32|Base Total Invoiced Cost | | |136|Gift Message|
|33|Base Total Offline Refunded | | |137|Base Customer Balance Amount|
|34|Base Total Online Refunded | | |138|Customer Balance Amount|
|35|Base Total Paid | | |139|Base Customer Balance Invoiced|
|36|Base Total Qty Ordered | | |140|Customer Balance Invoiced|
|37|Base Total Refunded | | |141|Base Customer Balance Refunded|
|38|Discount Amount | | |142|Customer Balance Refunded|
|39|Discount Canceled | | |143|Bs Customer Bal Total Refunded|
|40|Discount Invoiced | | |144|Customer Bal Total Refunded|
|41|Discount Refunded | | |145|Gift Cards|
|42|Grand Total | | |146|Base Gift Cards Amount|
|43|Shipping Amount | | |147|Gift Cards Amount|
|44|Shipping Canceled | | |148|Base Gift Cards Invoiced|
|45|Shipping Invoiced | | |149|Gift Cards Invoiced|
|46|Shipping Refunded | | |150|Base Gift Cards Refunded|
|47|Shipping Tax Amount | | |151|Gift Cards Refunded|
|48|Shipping Tax Refunded | | |152|Gw Id|
|49|Store To Base Rate | | |153|Gw Allow Gift Receipt|
|50|Store To Order Rate | | |154|Gw Add Card|
|51|Subtotal | | |155|Gw Base Price|
|52|Subtotal Canceled | | |156|Gw Price|
|53|Subtotal Invoiced | | |157|Gw Items Base Price|
|54|Subtotal Refunded | | |158|Gw Items Price|
|55|Tax Amount | | |159|Gw Card Base Price|
|56|Tax Canceled | | |160|Gw Card Price|
|57|Tax Invoiced | | |161|Gw Base Tax Amount|
|58|Tax Refunded | | |162|Gw Tax Amount|
|59|Total Canceled | | |163|Gw Items Base Tax Amount|
|60|Total Invoiced | | |164|Gw Items Tax Amount|
|61|Total Offline Refunded | | |165|Gw Card Base Tax Amount|
|62|Total Online Refunded | | |166|Gw Card Tax Amount|
|63|Total Paid | | |167|Gw Base Price Invoiced|
|64|Total Qty Ordered | | |168|Gw Price Invoiced|
|65|Total Refunded | | |169|Gw Items Base Price Invoiced|
|66|Can Ship Partially | | |170|Gw Items Price Invoiced|
|67|Can Ship Partially Item | | |171|Gw Card Base Price Invoiced|
|68|Customer Is Guest | | |172|Gw Card Price Invoiced|
|69|Customer te tify | | |173|Gw Base Tax Amount Invoiced|
|70|Billing Address | | |174|Gw Tax Amount Invoiced|
|71|Customer Group | | |175|Gw Items Base Tax Invoiced|
|72|Edit Increment | | |176|Gw Items Tax Invoiced|
|73|Email Sent | | |177|Gw Card Base Tax Invoiced|
|74|Forced Shipment With Invoice | | |178|Gw Card Tax Invoiced|
|75|Payment Auth Expiration | | |179|Gw Base Price Refunded|
|76|Quote Address | | |180|Gw Price Refunded|
|77|Quote | | |181|Gw Items Base Price Refunded|
|78|Shipping Address | | |182|Gw Items Price Refunded|
|79|Adjustment Negative | | |183|Gw Card Base Price Refunded|
|80|Adjustment Positive | | |184|Gw Card Price Refunded|
|81|Base Adjustment Negative | | |185|Gw Base Tax Amount Refunded|
|82|Base Adjustment Positive | | |186|Gw Tax Amount Refunded|
|83|Base Shipping Discount Amount | | |187|Gw Items Base Tax Refunded|
|84|Base Subtotal Incl Tax | | |188|Gw Items Tax Refunded|
|85|Base Total Due | | |189|Gw Card Base Tax Refunded|
|86|Payment Authorization Amount | | |190|Gw Card Tax Refunded|
|87|Shipping Discount Amount | | |191|Reward Points Balance|
|88|Subtotal Incl Tax | | |192|Base Reward Currency Amount|
|89|Total Due | | |193|Reward Currency Amount|
|90|Weight | | |194|Base Rwrd Crrncy Amt Invoiced|
|91|Customer Dob | | |195|Rwrd Currency Amount Invoiced|
|92|Increment Id | | |196|Base Rwrd Crrncy Amnt Refnded|
|93|Applied Rule Ids | | |197|Rwrd Crrncy Amnt Refunded|
|94|Base Currency Code | | |198|Reward Points Balance Refund|
|95|Customer Email | | |199|Reward Points Balance Refunded|
|96|Customer Firstname | | |200|Reward Salesrule Points|
|97|Customer Lastname | | |201|Giftcert Code|
|98|Customer Middlename | | |202|Giftcert Amount|
|99|Customer Prefix | | |203|Base Giftcert Amount|
|100|Customer Suffix | | |204|Giftcert Amount Invoiced|
|101|Customer Taxvat | | |205|Base Giftcert Amount Invoiced|
|102|Discount Description | | |206|Giftcert Amount Credited|
|103|Ext Customer Id | | |207|Base Giftcert Amount Credited|
|104|Ext Order Id | | |208|Giftcert New Gcs|
| | | | |209|Urf Id|✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SOA | Sales Order Address ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|Order | | |14|Country Id|
|2|Customer Address Id | | |15|Firstname|
|3|Quote Address | | |16|Address Type|
|4|Region Id | | |17|Prefix|
|5|Customer | | |18|Middlename|
|6|Fax | | |19|Suffix|
|7|Region | | |20|Company|
|8|Postcode | | |21|Vat Id|
|9|Lastname | | |22|Vat Is Valid|
|10|Street | | |23|Vat Request Id|
|11|City | | |24|Vat Request Date|
|12|Email | | |25|Vat Request Success|
|13|Telephone | | |26|Giftregistry Item Id|
| | | | |27|Urf Id|✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SOG | Sales Order Grid ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|Order |✔| |9|Total Paid|
|2|Status | | |10|Increment Id|
|3|Store | | |11|Base Currency Code|
|4|Store Name | | |12|Order Currency Code|
|5|Customer | | |13|Shipping Name|
|6|Base Grand Total | | |14|Billing Name|
|7|Base Total Paid | | |15|Created At|
|8|Grand Total | | |16|Updated At|
| | | | |17|Urf Id|✔ |
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SOI | Sales Order Item ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|Order | ✔ | |49|Ext Order Item Id|
|2|Parent Item | | |50|Locked Do Invoice|
|3|Quote Item | | |51|Locked Do Ship|
|4|Store | | |52|Price Incl Tax|
|5|Created At | | |53|Base Price Incl Tax|
|6|Updated At | | |54|Row Total Incl Tax|
|7|Sku | | |55|Base Row Total Incl Tax|
|8|Product Type | | |56|Hidden Tax Amount|
|9|Product Options | | |57|Base Hidden Tax Amount|
|10|Weight | | |58|Hidden Tax Invoiced|
|11|Is Virtual | | |59|Base Hidden Tax Invoiced|
|12|Name | | |60|Hidden Tax Refunded|
|13|Description | | |61|Base Hidden Tax Refunded|
|14|Applied Rule Ids | | |62|Is minal|
|15|Additional Data | | |63|Tax Canceled|
|16|Free Shipping | | |64|Hidden Tax Canceled|
|17|Is Qty Decimal | | |65|Tax Refunded|
|18| Discount | | |66|Base Tax Refunded|
|19|Qty Backordered | | |67|Discount Refunded|
|20|Qty Canceled | | |68|Base Discount Refunded|
|21|Qty Invoiced | | |69|Gift Message|
|22|Qty Ordered | | |70|Gift Message Available|
|23|Qty Refunded | | |71|Base Weee Tax Applied Amount|
|24|Qty Shipped | | |72|Base Weee Tax Applied Row Amnt|
|25|Base Cost | | |73|Weee Tax Applied Amount|
|26|Price | | |74|Weee Tax Applied Row Amount|
|27|Base Price | | |75|Weee Tax Applied|
|28|Original Price | | |76|Weee Tax Disposition|
|29|Base Original Price | | |77|Weee Tax Row Disposition|
|30|Tax Percent | | |78|Base Weee Tax Disposition|
|31|Tax Amount | | |79|Base Weee Tax Row Disposition|
|32|Base Tax Amount | | |80|Event Id|
|33|Tax Invoiced | | |81|Giftregistry Item Id|
|34|Base Tax Invoiced | | |82|Gw Id|
|35|Discount Percent | | |83|Gw Base Price|
|36|Discount Amount | | |84|Gw Price|
|37|Base Discount Amount | | |85|Gw Base Tax Amount|
|38|Discount Invoiced | | |86|Gw Tax Amount|
|39|Base Discount Invoiced | | |87|Gw Base Price Invoiced|
|40|Amount Refunded | | |88|Gw Price Invoiced|
|41|Base Amount Refunded | | |89|Gw Base Tax Amount Invoiced|
|42|Row Total | | |90|Gw Tax Amount Invoiced|
|43|Base Row Total | | |91|Gw Base Price Refunded|
|44|Row Invoiced | | |92|Gw Price Refunded|
|45|Base Row Invoiced | | |93|Gw Base Tax Amount Refunded|
|46|Row Weight | | |94|Gw Tax Amount Refunded|
|47|Base Tax Before Discount | | |95|Qty Returned|
|48|Tax Before Discount | | |96|Urf Id|✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SOP | Sales Order Payment ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|Order | ✔ | |31|Cc Status Description|
|2|Base Shipping Captured | | |32|Echeck Type|
|3|Shipping Captured | | |33|Cc Debug Response Serialized|
|4|Amount Refunded | | |34|Cc Ss Start Month|
|5|Base Amount Paid | | |35|Echeck Account Type|
|6|Amount Canceled | | |36|Last Trans Id|
|7|Base Amount Authorized | | |37|Cc Cid Status|
|8|Base Amount Paid Online | | |38|Cc Owner|
|9|Base Amount Refunded Online | | |39|Cc Type|
|10|Base Shipping Amount | | |40|Po Number|
|11|Shipping Amount | | |41|Cc Exp Year|
|12|Amount Paid | | |42|Cc Status|
|13|Amount Authorized | | |43|Echeck Routing Number|
|14|Base Amount Ordered | | |44|Account Status|
|15|Base Shipping Refunded | | |45|Anet Trans Method|
|16|Shipping Refunded | | |46|Cc Debug Response Body|
|17|Base Amount Refunded | | |47|Cc Ss Issue|
|18|Amount Ordered | | |48|Echeck Account Name|
|19|Base Amount Canceled | | |49|Cc Avs Status|
|20|Quote Payment Id | | |50|Cc Number Enc|
|21|Additional Data | | |51|Cc Trans Id|
|22|Cc Exp Month | | |52|Paybox Request Number|
|23|Cc Ss Start Year | | |53|Address Status|
|24|Echeck Bank Name | | |54|Additional Information|
|25|Method | | |55|Cybersource Token|
|26|Cc Debug Request Body | | |56|Flo2cash Account Id|
|27|Cc Secure Verify | | |57|Ideal Issuer Id|
|28|Protection Eligibility | | |58|Ideal Issuer Title|
|29|Cc Approval | | |59|Ideal Transaction Checked|
|30|Cc Last4 | | |59|Paybox Question Number|
| | | | |61|Urf Id| ✔ |
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SOSH | Sales Order Status History ==
^ # ^ Column Name ^ Required?^
| 1 | Order | ✔ |
| 2 | Is Customer tified |
| 3 | Is Visible On Front |
| 4 | Comment |
| 5 | Status |
| 6 | Created At |
| 7 | Entity Name |
| 8 | Urf Id | ✔ |
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
=== SQ section ===
[[http://docs.magento.com/m1/ce/user_guide/sales/shopping-cart-quote-lifetime.html|Sales Quotes]]
== SQ | Sales Quote ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|Store | ✔ | |40|Customer Taxvat|
|2|Created At | | |41|Customer Gender|
|3|Updated At | | |42|Subtotal|
|4|Converted At | | |43|Base Subtotal|
|5|Is Active | | |44|Subtotal With Discount|
|6|Is Virtual | | |45|Base Subtotal With Discount|
|7|Is Multi Shipping | | |46|Is Changed|
|8|Items Count | | |47|Trigger Recollect|
|9|Items Qty | | |48|Ext Shipping Info|
|10|Orig Order Id | | |49|Gift Message|
|11|Store To Base Rate | | |50|Is Persistent|
|12|Store To Quote Rate | | |51|Customer Balance Amount Used|
|13|Base Currency Code | | |52|Base Customer Bal Amount Used|
|14|Store Currency Code | | |53|Use Customer Balance|
|15|Quote Currency Code | | |54|Gift Cards|
|16|Grand Total | | |55|Gift Cards Amount|
|17|Base Grand Total | | |56|Base Gift Cards Amount|
|18|Checkout Method | | |57|Gift Cards Amount Used|
|19|Customer | | |58|Base Gift Cards Amount Used|
|20|Customer Tax Class Id | | |59|Gw Id|
|21|Customer Group | | |60|Gw Allow Gift Receipt|
|22|Customer Email | | |61|Gw Add Card|
|23|Customer Prefix | | |62|Gw Base Price|
|24|Customer Firstname | | |63|Gw Price|
|25|Customer Middlename | | |64|Gw Items Base Price|
|26|Customer Lastname | | |65|Gw Items Price|
|27|Customer Suffix | | |66|Gw Card Base Price|
|28|Customer Dob | | |67|Gw Card Price|
|29|Customer te | | |68|Gw Base Tax Amount|
|30|Customer te tify | | |69|Gw Tax Amount|
|31|Customer Is Guest | | |70|Gw Items Base Tax Amount|
|32|Remote Ip | | |71|Gw Items Tax Amount|
|33|Applied Rule Ids | | |72|Gw Card Base Tax Amount|
|34|Reserved Order Id | | |73|Gw Card Tax Amount|
|35|Password Hash | | |74|Use Reward Points|
|36|Coupon Code | | |75|Reward Points Balance|
|37|Global Currency Code | | |76|Base Reward Currency Amount|
|38|Base To Global Rate | | |77|Reward Currency Amount|
|39|Base To Quote Rate | | |78|Giftcert Code|
| | | | |79|Urf Id|✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SQA | Sales Quote Address ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|Quote | ✔ | |47|Base Shipping Discount Amount|
|2|Created At | | |48|Subtotal Incl Tax|
|3|Updated At | | |49|Base Subtotal Total Incl Tax|
|4|Customer | | |50|Hidden Tax Amount|
|5|Save In Address Book | | |51|Base Hidden Tax Amount|
|6|Customer Address Id | | |52|Shipping Hidden Tax Amount|
|7|Address Type | | |53|Base Shipping Hidden Tax Amnt|
|8|Email | | |54|Shipping Incl Tax|
|9|Prefix | | |55|Base Shipping Incl Tax|
|10|Firstname | | |56|Vat Id|
|11|Middlename | | |57|Vat Is Valid|
|12|Lastname | | |58|Vat Request Id|
|13|Suffix | | |59|Vat Request Date|
|14|Company | | |60|Vat Request Success|
|15|Street | | |61|Gift Message Id|
|16|City | | |62|Base Customer Balance Amount|
|17|Region | | |63|Customer Balance Amount|
|18|Region Id | | |64|Gift Cards Amount|
|19|Postcode | | |65|Base Gift Cards Amount|
|20|Country Id | | |66|Gift Cards|
|21|Telephone | | |67|Used Gift Cards|
|22|Fax | | |68|Giftregistry Item Id|
|23|Same As Billing | | |69|Gw Id|
|24|Free Shipping | | |70|Gw Allow Gift Receipt|
|25|Collect Shipping Rates | | |71|Gw Add Card|
|26|Shipping Method | | |72|Gw Base Price|
|27|Shipping Description | | |73|Gw Price|
|28|Weight | | |74|Gw Items Base Price|
|29|Subtotal | | |75|Gw Items Price|
|30|Base Subtotal | | |76|Gw Card Base Price|
|31|Subtotal With Discount | | |77|Gw Card Price|
|32|Base Subtotal With Discount | | |78|Gw Base Tax Amount|
|33|Tax Amount | | |79|Gw Tax Amount|
|34|Base Tax Amount | | |80|Gw Items Base Tax Amount|
|35|Shipping Amount | | |81|Gw Items Tax Amount|
|36|Base Shipping Amount | | |82|Gw Card Base Tax Amount|
|37|Shipping Tax Amount | | |83|Gw Card Tax Amount|
|38|Base Shipping Tax Amount | | |84|Reward Points Balance|
|39|Discount Amount | | |85|Base Reward Currency Amount|
|40|Base Discount Amount | | |86|Reward Currency Amount|
|41|Grand Total | | |87|Giftcert Amount|
|42|Base Grand Total | | |88|Base Giftcert Amount|
|43|Customer tes | | |89|Giftcert Code|
|44|Applied Taxes | | |90|Base Giftcert Balances|
|45|Discount Description | | |91|Giftcert Balances|
|46|Shipping Discount Amount | | |92|Urf Id| ✔ |
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SQAI | Sales Quote Address Item ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|Parent Item | | |23|Name|
|2|Quote Address | ✔ | |24|Description|
|3|Quote Item | ✔ | |25|Free Shipping|
|4|Created At | | |26|Is Qty Decimal|
|5|Updated At | | |27|Price|
|6|Applied Rule Ids | | |28|Discount Percent|
|7|Additional Data | | |29| Discount|
|8|Weight | | |30|Tax Percent|
|9|Qty | | |31|Base Price|
|10|Discount Amount | | |32|Base Cost|
|11|Tax Amount | | |33|Price Incl Tax|
|12|Row Total | | |34|Base Price Incl Tax|
|13|Base Row Total | | |35|Row Total Incl Tax|
|14|Row Total With Discount | | |36|Base Row Total Incl Tax|
|15|Base Discount Amount | | |37|Hidden Tax Amount|
|16|Base Tax Amount | | |38|Base Hidden Tax Amount|
|17|Row Weight | | |39|Gift Message|
|18|Product Id | | |40|Gw Id|
|19|Super Product Id | | |41|Gw Base Price|
|20|Parent Product Id | | |42|Gw Price|
|21|Sku | | |43|Gw Base Tax Amount|
|22|Image | | |44|Gw Tax Amount|
| | | | |45|Urf Id|✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SQI | Sales Quote Item ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|Quote | ✔ | |30|Product Type|
|2|Created At | | |31|Base Tax Before Discount|
|3|Updated At | | |32|Tax Before Discount|
|4|Sku | | |33|Original Custom Price|
|5|Store | | |34|Redirect Url|
|6|Parent Item | | |35|Base Cost|
|7|Is Virtual | | |36|Price Incl Tax|
|8|Name | | |37|Base Price Incl Tax|
|9|Description | | |38|Row Total Incl Tax|
|10|Applied Rule Ids | | |39|Base Row Total Incl Tax|
|11|Additional Data | | |40|Hidden Tax Amount|
|12|Free Shipping | | |41|Base Hidden Tax Amount|
|13|Is Qty Decimal | | |42|Gift Message|
|14|Discount | | |43|Weee Tax Disposition|
|15|Weight | | |44|Weee Tax Row Disposition|
|16|Qty | | |45|Base Weee Tax Disposition|
|17|Price | | |46|Base Weee Tax Row Disposition|
|18|Base Price | | |47|Weee Tax Applied|
|19|Custom Price | | |48|Weee Tax Applied Amount|
|20|Discount Percent | | |49|Weee Tax Applied Row Amount|
|21|Discount Amount | | |50|Base Weee Tax Applied Amount|
|22|Base Discount Amount | | |51|Base Weee Tax Applied Row Amnt|
|23|Tax Percent | | |52|Event Id|
|24|Tax Amount | | |53|Giftregistry Item Id|
|25|Base Tax Amount | | |54|Gw Id|
|26|Row Total | | |55|Gw Base Price|
|27|Base Row Total | | |56|Gw Price|
|28|Row Total With Discount | | |57|Gw Base Tax Amount|
|29|Row Weight | | |58|Gw Tax Amount|
| | | | |59|Urf Id|✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SQIO | Sales Quote Item Option ==
^ # ^ Column Name ^ Required?^
| 1 | Item | ✔ |
| 2 | Sku | ✔ |
| 3 | Code |
| 4 | Value |
| 5 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SQP | Sales Quote Payment ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
| 1 | Quote | ✔ | |13 | Cc Ss Start Month |
| 2 | Created At | | |14 | Cc Ss Start Year |
| 3 | Updated At | | |15 | Po Number |
| 4 | Method | | |16 | Additional Data |
| 5 | Cc Type | | |17 | Cc Ss Issue |
| 6 | Cc Number Enc | | |18 | Additional Information |
| 7 | Cc Last4 | | |19 | Paypal Payer Id |
| 8 | Cc Cid Enc | | |20 | Paypal Payer Status |
| 9 | Cc Owner | | |21 | Paypal Correlation Id |
|10 | Cc Exp Month | | |22 | Cybersource Token |
|11 | Cc Exp Year | | |23 | Ideal Issuer Id |
|12 | Cc Ss Owner | | |24 | Ideal Issuer List |
| | | | |25 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SQSR | Sales Quote Shipping Rate ==
^ # ^ Column Name ^ Required?^
| 1 | Address | ✔ |
| 2 | Created At |
| 3 | Updated At |
| 4 | Carrier |
| 5 | Carrier Title |
| 6 | Code |
| 7 | Method |
| 8 | Method Description |
| 9 | Price |
|10 | Error Message |
|11 | Method Title |
|12 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
=== SSH section ===
[[http://docs.magento.com/m1/ce/user_guide/order-processing/order-ship.html|Sales Shipping]]
== SSHIP | Sales Shipment ==
^ # ^ Column Name ^ Required?^
| 1 | Store |
| 2 | Total Weight |
| 3 | Total Qty |
| 4 | Email Sent |
| 5 | Order | ✔ |
| 6 | Customer |
| 7 | Shipping Address |
| 8 | Billing Address |
| 9 | Shipment Status |
|10 | Increment Id |
|11 | Created At |
|12 | Updated At |
|13 | Packages |
|14 | Shipping Label |
|15 | Urf Id |✔ |
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SSHIPC | Sales Shipment Comment ==
^ # ^ Column Name ^ Required?^
|1|Shipment| ✔|
|2|Is Customer tified|
|3|Is Visible On Front|
|4|Comment|
|5|Created At|
|6|Urf Id| ✔ |
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SSHIPG | Sales Shipment Grid ==
^ # ^ Column Name ^ Required?^
| 1 | Shipment | ✔ |
| 2 | Store |
| 3 | Total Qty |
| 4 | Order |
| 5 | Shipment Status |
| 6 | Increment Id |
| 7 | Order Increment Id |
| 8 | Created At |
| 9 | Order Created At |
|10 | Shipping Name |
|11 | Urf Id |✔ |
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SSHIPI | Sales Shipment Item ==
^ # ^ Column Name ^ Required?^
| 1 | Shipment | ✔|
| 2 | Row Total |
| 3 | Price |
| 4 | Weight |
| 5 | Qty |
| 6 | Sku |
| 7 | Order Item |
| 8 | Additional Data |
| 9 | Description |
|10 | Name |
|11 | Urf Id | ✔ |
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SSHIPT | Sales Shipment Track ==
^ # ^ Column Name ^ Required?^
| 1 | Shipment | ✔ |
| 2 | Weight |
| 3 | Qty |
| 4 | Order |
| 5 | Track Number |
| 6 | Description |
| 7 | Title |
| 8 | Carrier Code |
| 9 | Created At |
|10 | Updated At |
|11 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
=== SOT section ===
[[http://docs.magento.com/m1/ce/user_guide/configuration/sales/tax.html|Sales Order Tax]]
== SOT | Sales Order Tax ==
^ # ^ Column Name ^ Required?^
| 1 | Order |✔|
| 2 | Code |
| 3 | Title |
| 4 | Percent |
| 5 | Amount |
| 6 | Priority |
| 7 | Position |
| 8 | Base Amount |
| 9 | Process |
|10 | Base Real Amount |
|11 | Hidden |
|12 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
== SOTI | Sales Order Tax Item ==
^ # ^ Column Name ^ Required?^
| 1 | Tax | ✔|
| 2 | Item | ✔ |
| 3 | Tax Percent |
| 4 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
=== SPT section ===
[[http://docs.magento.com/m1/ce/user_guide/payments.html|Sales Payments]]
== SPT | Sales Payment Transaction ==
^ # ^ Column Name ^ Required?^
| 1 | Parent |
| 2 | Order | ✔|
| 3 | Payment | ✔ |
| 4 | Txn Id |
| 5 | Parent Txn Id |
| 6 | Txn Type |
| 7 | Is Closed |
| 8 | Additional Information |
| 9 | Created At |
|10 | Urf Id |✔|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
=== SRP section ===
[[http://docs.magento.com/m1/ce/user_guide/catalog/product-recurring-profile.html|Sales Recurring Profile]]
== SRP | Sales Recurring Profile ==
^ # ^ Column Name ^ Required?^ ^ # ^ Column Name ^ Required?^
|1|State | | |17|Billing Amount|
|2|Customer | | |18|Trial Period Unit|
|3|Store | | |19|Trial Period Frequency|
|4|Method Code | | |20|Trial Period Max Cycles|
|5|Created At | | |21|Trial Billing Amount|
|6|Updated At | | |22|Currency Code|
|7|Reference Id | | |23|Shipping Amount|
|8|Subscriber Name | | |24|Tax Amount|
|9|Start Datetime | | |25|Init Amount|
|10|Internal Reference Id | | |26|Init May Fail|
|11|Schedule Description | | |27|Order Info|
|12|Suspension Threshold | | |28|Order Item Info|
|13|Bill Failed Later | | |29|Billing Address Info|
|14|Period Unit | | |30|Shipping Address Info|
|15|Period Frequency | | |31|Profile Vendor Info|
|16|Period Max Cycles | | |32|Additional Info|
[[#fixed_rows_types|Back to the Table]]
[[urapidflow:sales|Back to the Top]]
=== Fixed Row CSV Sample ===
Below is the dummy sample of the CSV file for import
##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",,,,,,