User Tools

Site Tools


urfsales:v0.1:format

RapidFlowSales row format

While Product and Category records require a dynamic row format, which would allow flexible columns configuration, importing and exporting sales information in single file requires well defined and DB oriented format. We call it “fixed row format”.

Example of file with fixed format rows:

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

The file above will create or update gift message entry and add couple of entries to credit memo grid

Each row begins with row type identifier. For each imported row type there must be a type definition row.

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

* In following example ##GM determines the expected structure for gift message row. It declares that first column after GM identifier is the customer email, then it is the sender email, recipient email, the message and finally the unique RapidFlowSales identifier.

example.csv
##GM,customer,sender,recipient,message,urf_id
GM,test@user.com,test2@user.com,test2@user.com,"Lorem ipsum dolor sit amet, ...",df222b37-580b-5220-a57b-f0a9aie8rueu4

First few fields are always required, others are optional, row structure should not change much, but since third party modules can change database structure, the type definition row is required at all times. Only one definition row per import code is required.

This allows to combine different types of sales 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.

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 entity with same urf_id exists, then it is the same entity imported some time before.

When any of the entities references another sales entity, urf_id property is used for identifier.

Sales Row Types

Allowed actions

Row Type Create Update Description
GM X X Gift Message
SBA X X Sales Billing Agreement
SCM X X Sales Creditmemo
SCMC X X Sales Creditmemo Comment
SCMG X X Sales Creditmemo Grid
SCMI X X Sales Creditmemo Item
SI X X Sales Invoice
SIC X X Sales Invoice Comment
SIG X X Sales Invoice Grid
SII X X Sales Invoice Item
SO X X Sales Order
SOA X X Sales Order Address
SOG X X Sales Order Grid
SOI X X Sales Order Item
SOP X X Sales Order Payment
SOSH X X Sales Order Status History
SQ X X Sales Quote
SQA X X Sales Quote Address
SQAI X X Sales Quote Address Item
SQI X X Sales Quote Item
SQIO X X Sales Quote Item Option
SQP X X Sales Quote Payment
SQSR X X Sales Quote Shipping Rate
SSHIP X X Sales Shipment
SSHIPC X X Sales Shipment Comment
SSHIPG X X Sales Shipment Grid
SSHIPI X X Sales Shipment Item
SSHIPT X X Sales Shipment Track
SOT X X Sales Order Tax
SOTI X X Sales Order Tax Item
SPT X X Sales Payment Transaction
SRP X X Sales Recurring Profile

Examples

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