We run an e-commerce site with CS-Cart version 2.2.3 and need a product compatibility tool that'll show on all product pages. The compatibility dropdown to will appear as shown in the attached picture.
When a user lands on a product page, all dropdowns except the "Brand" should be greyed out, and when the user chooses the desired "Brand", the dropdown to the right is filtered (according to what was chosen for "Brand") and enabled. The same process goes for the other dropdowns, until the user selects the "Model" dropdown, which once selected, will cause the script to run the compatibility query and display the results (i.e. the "compatible" vs "not compatible message"
The addon will work like the ebay compatibility tool (example: [url removed, login to view]). The compatibility text will be based on the product on the page, meaning that once a combination of "Brand", "Family", "Series", and "Model" is chosen, we have two outcomes:
1) A message comes up (just like on ebay) that says: This product is compatible with "Brand", "Family", "Series", and "Model"
2) A message comes up (just like on ebay) that says: This product is not compatible with "Brand", "Family", "Series", and "Model"
In addition, as long as a user selects the "Brand", "Family", "Series", and "Model", the tool will show the compatibility results, even without clicking the "GO" button.
On the backend, we want to be able to use the existing CS-Cart import functionality, using an excel sheet with the following columns (there are other columns too but they aren't relevant to the addon functionality). See attachment "Import_table"
Show: this token tells the table of an item will be displayed or not in the compatibility table. The format is "Y" or "N"
ProductC: This field is not displayed on the product pages. We sell multiple products (e.g. batteries, screens), so the script must know the correct contents for the other dropdowns based on what product the user lands on. We must be able to add any new product we want by using the excel sheet.
BrandC: be able to add any new Brand we want by using the excel sheet and it will be reflected in the dropdown
FamilyC: be able to add any new Family we want by using the excel sheet and it will be reflected in the dropdown
SeriesC: be able to add any new Series we want by using the excel sheet and it will be reflected in the dropdown
ModelC: be able to add any new Model we want by using the excel sheet and it will be reflected in the dropdown
Once we install the CS-Cart plugin we can change it in the admin area as opposed to the source code. We'll be able to enter the text to display by using the GUI in the CS-Cart Addons section. We will enter a string to display and we must be able to dynamically insert the "Brand" "Family" "Series" "Model" tag. E.g., if we want to create the string which tell the customer if a product is compatible or not on our English language site, the GUI in the CS-Cart Addons Section would look like shown in the "input_fields" attached file.
In the admin area, we'll have an Export clicks option, which gives a excel file with the following information, so we can track how often customers have searched for any given product compatibility (see the "export_table" attached file). We also want a feature in the admin area that lets us "reset" the "Queries" field count on all items.
If the customer lands on the product page for an HP Pavilion DV6-123EL Battery (product code 462889-0001), and wants to know if his laptop (HP Pavilion DV8-4567RT, which has a product code of 462889-2356) is compatible with this battery, the script will see that the first product's Part Number is 462889 and the second one is also 462889, so it'll determine that they are compatible, and display the message described above.