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:

  1. Select Purchase Orders from the left vertical menu
  2. Scroll to the bottom of the page
  3. 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

Did this answer your question?