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 on the product detail page, very similar to the link above). This spreadsheet will have the column names be the individual options, along with the first column bearing a unique ID.
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 downloading, editing, and pasting the spreadsheet data.
In the event that the user inputs information for 50 products into the spreadsheet, each of these products 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 product options which 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.
Also, as far as the option labels/titles, you should determine how best to manage this. Whether it is possible to capture the option titles from the excel spreadsheet, or whether it will be necessary to input the options into the administration section before it is able to recognize any textbox input, you let me know which one will take less time.
A sample of the spreadsheet which contains data for processing is attached. If you would like a sample of this process in action, message me and ask me for a link to a sample website.
7 freelancers are bidding on average $267 for this job
Hi, [url removed, login to view] of our busy schedule the delivery time is 14 days instead of 5. hence the low [url removed, login to view] confirmation is necessary. thankx Digisync Online Services.