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
-
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
-
Go to the 'Sale Lots' tab.
-
Click on 'Import Sale CSV'.
Step 3: Download Template File 0: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
-
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
-
Return to the Greenhouse application.
-
Drag and drop the completed CSV file into the designated area.
Step 6: Map Vendors 2: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
-
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
-
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.