Looking for someone to create an online store with the following specifications.
The shop will have 4 main groups of products with 5 to 15 sub-groups for each main group.
All shop products and groups need to be automatically created and updated from a xls spread sheet.
Basically I would like to be able to just upload XLS file with products names and details and the data should extract to database automatically.
- all product groups to be created from a column in a spread sheet
- all product names to be added or removed according to column data in a spread sheet
- all product quantities to be added or removed according to a column in a spread sheet
There are 12 columns in a spreadsheet in total which need to be added to store database.
The data in spreadsheet changes frequently. For example quantities change on a daily basis.
When the quantity is bellow certain level, for example less than 10, the product should be removed.
If the product does not exist on a spread sheet any more and still exists in a database that product should be removed from the database.
The shop should have search option as well.
I do not need payment facility.
Instead I need order output in XLS format emailed to predefined email or email notification with the link to download the file/order.