Export - Material Purchase Orders

As a business owner, you may want to see how much money you are spending with each of your suppliers for raw materials. Or, you may want to see the quantity of materials you are purchasing from each supplier. Uphance allows you to export your Material Purchase Orders to Excel or CSV formats with or without quantities.

To export your raw material purchase orders:

Select Purchase Orders from the left vertical menu
Scroll to the bottom of the page
Select Export CSV or Excel format with or without quantities

Fields Common to all export formats

production_order_number
manufacturer_name
season
order_date
items_total
items_tax
subtotal
total_tax
grand_total
total_quantity
tax_level
currency
status
delivery_address_line_1
delivery_address_line_2
delivery_address_line_3
delivery_address_line_city
delivery_address_line_state
delivery_address_line_postcode
delivery_address_line_country
label
due_date
tax_calc_method

Fields unique to the Export "With Quantities"

line_item_season
line_item_product_name
line_item_product_identifier
line_item_category
line_item_subcategory
line_item_product_ean
line_item_product_color
line_item_sku_#
line_item_product_size
line_item_unit_price
line_item_quantity
material_name
material_color
material_size
material_quantity

Fields for the Export of Deliveries:

manufacturer
production_order_number
production_order_season
production_order_currency
prod-uction_order_tax_level
production_order_label
delivery_created_at
delivery_checked_in_at
delivery_reference
delivery_address_line_1
delivery_address_line_2
delivery_address_line_3
delivery_address_line_city
delivery_address_line_state
delivery_address_line_postcode
delivery_address_line_country
line_item_product_name
line_item_product_identifier
line_item_product_ean
line_item_product_warehouse_location
line_item_product_color
line_item_sku_#
line_item_product_size
line_item_unit_price
line_item_quantity