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