Skip to content

Instantly share code, notes, and snippets.

@rabinshr

rabinshr/query_result.csv

Last active January 25, 2016 04:38
Show Gist options
  • Save rabinshr/3c1ea791aa2f897b33d0 to your computer and use it in GitHub Desktop.
Save rabinshr/3c1ea791aa2f897b33d0 to your computer and use it in GitHub Desktop.
Download ZIP
Query Results dump
Raw
query_result.csv
itemid shipid itemprodid itemordprodid itemprodsku itemprodname itemqty itemprodoptions itemprodvariationid itemprodeventname itemprodeventdate product_attribute_combination_id product_attributes is_bundled_product ordprodbin prodname url
28 27 76 10 Test Product 1 0 NULL 0 NULL 0 Test Product /test-product/
29 27 77 11 WeightFactoredProduct 1 0 NULL 0 NULL 1 WeightFactoredProduct /weightfactoredproduct/
Raw
query_result_fix.csv
orderprodid ordprodsku ordprodbin ordprodname ordprodtype base_price price_ex_tax price_inc_tax price_tax base_total total_ex_tax total_inc_tax total_tax ordprodweight width height depth ordprodqty orderorderid ordprodid base_cost_price cost_price_inc_tax cost_price_ex_tax cost_price_tax ordprodrefunded ordprodrefundamount ordprodreturnid ordprodoptions ordprodvariationid ordprodwrapid ordprodwrapname base_wrapping_cost wrapping_cost_ex_tax wrapping_cost_inc_tax wrapping_cost_tax ordprodwrapmessage ordprodqtyshipped ordprodeventname ordprodeventdate ordprodfixedshippingcost order_address_id ebay_item_id applied_discounts ebay_transaction_id product_type_id parent_order_product_id is_bundled_product attributes_hash itemprodsku itemprodname itemprodoptions product_attributes itemprodeventdate itemprodeventname itemqty prodname url
10 Test Product physical 2.0000 2.0000 2.0000 0.0000 2.0000 2.0000 2.0000 0.0000 2.0000 1.0000 1.0000 1.0000 1 108 76 0.0000 0.0000 0.0000 0.0000 0 0.0000 0 0 0 0.0000 0.0000 0.0000 0.0000 1 NULL 0 0.0000 9 15 NULL 0 b2c60063a9b1552ddd30839584e59c4d Test Product 0 NULL 1 Test Product /test-product/
11 WeightFactoredProduct physical 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 1.0000 1.0000 1.0000 1 108 77 0.0000 0.0000 0.0000 0.0000 0 0.0000 0 0 0 0.0000 0.0000 0.0000 0.0000 1 NULL 0 0.0000 9 NULL 10 1 WeightFactoredProduct 0 NULL 1 WeightFactoredProduct /weightfactoredproduct/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment