Objective:
Create a web application using Vercel AI that functions as an order printer for TikTok Shop orders. The app should generate a consolidated packing slip for each customer based on uploaded CSV data.
Functional Requirements:
File Upload:
User uploads a CSV file containing order data.
Support for standard CSV format as exported from TikTok Shop.
Data Processing:
Identify orders from the same customer by checking the "Buyer Username" (Column 38) in the CSV.
If the same username appears multiple times, consolidate all related orders into a single packing slip.
Packing Slip Generation:
Use the packing slip format as shown in the provided example image.
Include the following details on the packing slip:
Header:
Order number (Column 1)
Printing date and time (current date and time when printed)
Customer Information:
Name (Column 41)
Address (Columns 49, 50, 51, 52, 53)
Phone (Column 42)
Product Information:
Product image (if available, else leave blank)
Product name (Column 8)
SKU (Column 6)
Seller SKU (Column 7)
Quantity (Column 10)
Order ID (Column 1)
Footer:
TikTok Shop logo and contact information.
Layout Requirements:
Packing slip design should match the example provided.
Use a clean and professional design suitable for printing.
Ensure A4 size formatting.
Functional Flow:
User uploads the CSV file.
The app processes the file, identifying customers with multiple orders.
Consolidates items into a single slip per customer.
Generates a PDF or printable HTML file for each packing slip.
Technical Specifications:
Framework: Use Vercel AI for hosting.
Frontend: HTML, CSS (responsive design for different devices)
Backend: Node.js or similar for file processing and PDF generation.
Output: PDF or directly printable HTML page.
Additional Notes:
Include error handling for invalid file formats or corrupted data.
Include a progress bar while processing large files.
Ensure that the app runs efficiently for files containing multiple orders.
Loading...
Develop a web application using Vercel AI to function as an order printer specifically tailored for TikTok Shop orders. The application should process uploaded CSV data to generate consolidated packing slips for each customer. The application should extract data starting from the second row of the CSV file, treating the first row as a header. The application should identify and consolidate orders from the same customer based on the 'Buyer Username' (Column 38) in the CSV. If a customer has multiple orders, all related orders should be combined into a single packing slip. The packing slip should include the following details:
Header:
Order number (Column 1) Printing date and time (current date and time when printed) Customer Information: Name (Column 41) Address (Columns 49, 50, 51, 52, 53) Phone (Column 42) Product Information: Product image (if available, otherwise leave it blank) Product name (from Column 8) SKU (from Column 6) Seller SKU (Column 7) Quantity (from Column 10) Order ID (Column 1) Footer: TikTok Shop logo and contact information.
The packing slip design should match the example provided, using a clean and professional design suitable for printing, and formatted for A4 size. The functional flow should be as follows: The user uploads the CSV file. The app processes the file, identifying customers with multiple orders. It then consolidates items into a single slip per customer and generates a PDF or printable HTML file for each packing slip. The technical specifications should include the use of Vercel AI for hosting, HTML, CSS for the frontend (with responsive design), and Node.js or a similar technology for backend file processing and PDF generation. Error handling for invalid file formats or corrupted data should be included, along with a progress bar for processing large files. The application should be optimized for efficient processing of files containing numerous orders. The output should be a PDF or directly printable HTML page. The application should display the product image if available, otherwise leave it blank. The output should be formatted similarly to the attached images.
Loading...
The first row should be used as a header, meaning data should not be taken from it. Start extracting data from Column 1 (Order Number).
Include the printing date and time (current date and time when printed).
Display the product image (if available, otherwise leave it blank).
Include the following details:
Product name (from Column 8)
SKU (from Column 6)
Quantity (from Column 10)
The output should be formatted similarly to the attached images.