Skip to content
English
  • There are no suggestions because the search field is empty.

7.3.3 - Importing Sale Lots from a CSV file into a Clearing Sale

Steps to import sale data using a CSV file

 

Key Steps

Step 1: Create a Sale 0:09

generated-image-at-00:00:09

  • Open the AgriNous application.

  • Create a new sale by following the standard procedure.

  • Title the sale appropriately (e.g., 'CSV Import Test').

  • If unsure how to create a sale, refer to the 'How to Create a Clearing Sale' video.

Step 2: Navigate to Import Sale CSV 0:32

generated-image-at-00:00:32

  • Go to the 'Sale Lots' tab.

  • Click on 'Import Sale CSV'.

Step 3: Download Template File 0:41

generated-image-at-00:00:41

  • Download the provided template file for CSV import.

  • Review the required fields: lot number, title, quantity, and vendor name.

Step 4: Fill in the CSV Template 1:20

generated-image-at-00:01:20

  • Open the downloaded CSV template.

  • Enter the required information:

    • Lot number

    • Title

    • Quantity

    • Vendor name

  • Optionally, fill in additional fields as needed.

Step 5: Upload the CSV File 2:31

generated-image-at-00:02:31

  • Return to the Greenhouse application.

  • Drag and drop the completed CSV file into the designated area.

Step 6: Map Vendors 2:50

generated-image-at-00:02:50

  • Click to map the vendors from the CSV to the system.

  • Ensure all businesses from the CSV are correctly matched to those in Agronouse.

Step 7: Import Sale Data 3:23

generated-image-at-00:03:23

  • Confirm that all mappings are correct.

  • Click to import the sale data.

  • Verify that vendors have been created successfully.

Step 8: Proceed to Quick Sale Tab 3:55

generated-image-at-00:03:55

  • Navigate to the 'Quick Sale' tab to continue with selling lots.

Cautionary Notes

  • Ensure all required fields are filled out correctly to avoid import errors.

  • Double-check vendor mappings to prevent data discrepancies.

Tips for Efficiency

  • Use consistent naming conventions for lot titles to streamline the mapping process.

  • Save a copy of the filled CSV template for future imports to save time.

Link to Loom

https://loom.com/share/0d337d3ea56f43d0b68ca3553ab56ed3