currently running an opencart installation with the year/make/model plugin installed (as well as others). there are a little over 65,000 products in the database. i need to be able to export AND import all relevant information (products, categories, manufacturers, etc - see this plugin as a start: [url removed, login to view] ) as well as the matching year/make/model information (can provide plugin if needed). the output needs to be in an easily editable csv or xls file that can be opened in microsoft excel.
just to make sure this is understood... we need to take the plugin i linked to above or rebuild it... your choice), and add items from other tables into the import/export functionality. i have attached a spreadsheet with the exact fields... you will notice the only difference between this and the plugin linked above, is the inclusion of YMM_YEAR, YMM_MAKE, YMM_MODEL which are in separate tables in the db.
adding the spreadsheet
PLEASE BE AWARE - this is a large database (65,000 products) so you will need to find a creative way to accomplish this. it needs to be exported and re-imported through this solution. it can be done in a csv written to disk, or an xls... whatever you can make work. but i need it done in the time frame you offer, and not a second over.
I know the Import/Export Tool allows the admin user to do a bulk export of all the categories, products, and product options to an Excel spreadsheet [url removed, login to view] will do it. This is my "OPENCART" Profile [url removed, login to view] Mere
10 freelancers are bidding on average $186 for this job
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
Hi, I am experienced Opencart developer. Can you please let me know which YMM extension you are using to see the database structure? Thanks, Harsh