For certain products that I am selling (for example, Product XYZ), a user should be able to click on the Product XYZ to go to its detail page, and if this product is one whereby each product quantity of the total quantity of that product requires unique information (ie. Options), I would like them to be able to enter all of that information into a spreadsheet (this spreadsheet will be available for download on the product detail page).)
After the user enters all their data on the spreadsheet, they can copy and paste the selected number of rows into a textbox on the product detail page. Note: the textbox should only appear if they select a quantity of more than 1. If there is a quantity of 1, only one set of options is necessary, and the user can manually enter into the website the data for that 1 sample. This function is already handled by x-cart.
In the event that they select a quantity greater than 1 for Product XYZ, the textbox appears, along with the directions for the spreadsheet.
Upon pasting all of the rows of the spreadsheet (each has a unique ID, in the case of the above spreadsheet, it is the sample ID) In the event that the user inputs information for 50 unique samples, each of these samples are then added with their corresponding options, and are displayed on a confirmation page. Upon confirmation that all the information is accurate, the user can then add those items into the shopping cart. All of the items will be added to the shopping cart with THE SAME SKU as Product XYZ, since they are nothing more than multiple quantities of Product XYZ.
Note: None of the options that are customizable involve product variants, price modifiers, or anything of that nature. They are simply options for each quantity of a product, whereby the product price, tax, etc stays the same.
Ultimately, this functionality will be similar to having the user selecting a quantity of 1, entering the options that are standard features of x-cart, and adding that item to the cart. If they repeated this process 50 times and entered manually all the data that is contained on the spreadsheet, they would achieve the same results as having copied and pasted the information from the spreadsheet into the textbox for processing. It is to simplify the order process for customers requiring multiple quantities of the same Product XYZ, since x-cart limitations do not allow them to customize options after a quantity greater than 1 is selected on the product detail page.
In the admin area, I would like to be able to designate whether the product should have this capability (of accepting text-box entries from an excel spreadsheet template) in the "options" feature of product management. Not all products will have this capability. Only ones that are designated as such should.
After they entier all 50 products into the spreadsheet and then copy them into the textbox, they should be able to confirm before adding those items to the cart. NOTE: when the cart page is now displayed, all 50 items with their specific options should NOT be displayed. Rather, only that one item (Product XYZ ) should be displayed with a quantity of 50. Those "options" for each individual sample (50 total set of options) should be saved and stored and modifiable by the user (maybe as an expandable section of the Product XYZ?), but should not appear on the checkout page as 50 individual products being added, nor on the invoice. The way it is currently, is that when a user orders Product XYZ with QTY of 50, only one instance of Product XYZ shows up on the invoice as well as in the customer order history, and next to it it shows quantity of 50. But as mentioned above, even with the new option groups for each quantity, i would still like this layout and display to remain the same. However, maybe there can be a little expandable "+" next to Product XYZ in the order history or on the checkout page to display ALL the details for each individual sample. Same in the customer order history area. The invoice should have the expandable "+" if they would like to view details about all 50 of their samples. If not, they should just see one instance of Product XYZ, quantity of 50, and other relevant information.
NOTE: The method described above is the "excel" method for capturing multiple quantities of a product. Additionally, when they click on a product to view its detail page, they should be given two options: Standard method (where if they select quantity of > 1, for instance, 10, the options section reloads with 10 groups of options for each quantity, where they are able to manually enter data or select from dropdown menus on the web form) The second method is the excel method, where if they choose that method, the detail page reloads and shows instructions for downloading the excel template, and has the textbox area where they can paste the contents into.
This project is extremely time sensitive... let me know if this can be done.