Find Jobs
Hire Freelancers

Admin features for OSCommerce

$250-750 USD

Ukończony
Opublikowano ponad 9 lat temu

$250-750 USD

Płatne przy odbiorze
We have an existing catalog side feature which automatically draws Specification Tables for individual products and a Specification Summary Table at the top of the category display. We require the admin side to be written so that we can create new types of specification tables and input the column headings (e.g. we have 2 set up already, "tripod" and "monopod", others could be things like "satchel" or "lens"). We also need to be able to associate a Specification Type with a Product and input and edit the table contents for that product. See attached images of the database tables. While we need to be able to edit existing table headings we do not need to be able to delete table types as this adds significant complexity. You can see the catalog side at [login to view URL] - select the "Tripods" or Monopods" categories and any product in those categories to see how the specification tables are displayed. Existing Tables: products_spec_type - Contains one row for each type of table - each row contains a sort order field, the name of the specification table type, the number of data fields in the specification table and 12 fields (f1_name ….f12_name) which contain the headings to be used in the specification table products_spec_nnnnnn - a new table is created for each different specification type ("nnnnnn") - these tables contain a record for each product which has a product spec type of "nnnnnn". Two examples are set up in the database - products_spec_tripod and products_spec_monopod. We require 3 things coded on the Admin side (OSCommerce 2.3.3.4): 1. Create/Edit a Specification table type. In the Admin area the user is given a list of the existing table types to edit, or the option to create a new table. (If editing, the name of the table and the number of fields cannot be changed) When creating a new table the user is prompted for a name for the new table which is validated to contain only characters a..z and 0..9 and no spaces. They are prompted for the number of fields in the table (maximum of 12). Input fields are then generated up to the number specified in the previous step and the user can then input the field headings to be used in the tables into these fields. The first field is pre filled to "Model" and cannot be edited. On Save, the new database table is created in the form products_spec_xxxxxxx where "xxxxxxx" is the name of the new specification table type. 2: When a Category is edited/created have the ability to select a table type from a sorted list of table types generated from the existing database table "products_spec_type". The selected table type is then written to the "categories_spec_table" field in the "category_description" database table. The list should have the default option of "none" in which case the "categories_spec_table" field is set to blank. If the Category already has a table type associated with it then that table type should be the default when the Category is edited. See attached mock-up of how this might look. 3: When editing/creating a product in Admin have the ability to select a table type from a sorted list (default "none") of table types generated from the existing database table "products_spec_type". If the product already has a table type associated with it then this should be selected by default on entering the admin product editing screen. When selected the available fields for the table type are displayed for editing/input - the field headings are also displayed. The first of these fields is pre filled with the products model number and cannot be edited. On saving the selected specification table type is then written to the field "products_spec_type" in database table "products" and the data for the fields is written to the database table "products_spec_xxxxxxx" where "xxxxxxx" is the name of the table type selected.
Identyfikator projektu: 6405382

Informację o projekcie

23 ofert
Zdalny projekt
Aktywny 10 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
Hi I checked the site and requirement. One query: as in shown image there is 11 fileds So will it fixed or can be more than 11 fields And let me when to start the project Thanks swami
$277 USD w 5 dni
4,8 (84 opinii)
5,5
5,5
23 freelancers are bidding on average $569 USD for this job
Awatar Użytkownika
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
$515 USD w 15 dni
4,8 (401 opinii)
8,2
8,2
Awatar Użytkownika
Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce,vBulletin , Zen cart-Drupal I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
$515 USD w 15 dni
4,7 (487 opinii)
8,3
8,3
Awatar Użytkownika
Hi, I have 12+ yrs. experience of osCommerce/opencart/zencart/wordpress/woocommerce/prestashop/Cre Loaded. I have already worked on hundreds of ecommerce websites including template integration, module installation and custom module development. I have contributed 3 payment modules (eway, netbilling and ccavenue) to oscommerce community and developed many custom payment, shipping, reports and other modules for my clients. Please also visit the following link to see reviews for my experience and customers satisfaction. http://www.freelancer.com/users/feedback_138265.html Thanks for the detailed explanation. I understand the logic to associate a table type to a product, but I do not understand the functionality of associating table type to a category. Where are you using categories association with table type on frontend? you can have tripod associated with category A, but you can select monopod for product 1 under the same category A. Please clarify. Regards Kavita
$578 USD w 5 dni
5,0 (318 opinii)
8,1
8,1
Awatar Użytkownika
Hello, I have seen your description carefully. I can know what you want now. I am very skilled in this field. I am ready to start work. Wait your message. Thanks.
$526 USD w 10 dni
5,0 (8 opinii)
5,6
5,6
Awatar Użytkownika
Hello There, Thanks for sharing your requirements with us. We are very much interested in doing the project as we are very much experienced in website design and development. We are expert in every HTML5,CMS/framework like WP, Drupal, Joomal,jQuery / Prototype!, CI, cake php. As well as we are experienced in ROR, Java. I will be grateful if you can share your requirements. Can we discuss the details of this project now?? Kind Regards, Kalyan
$368 USD w 10 dni
4,7 (13 opinii)
4,4
4,4
Awatar Użytkownika
I have read the details you have given. I have 6+ yrs of experience in PHP and PHP based scripts during my career I have worked on various big and complex projects. I have made unique, complex and different features to Oscommerce, Creloaded projects. I can make the required functionality as per your needs. If you feel fit let me know so we can discuss further about work and can start work immediately. Thanks
$555 USD w 10 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga AUSTRALIA
FLYNN ACT, Australia
5,0
10
Zweryfikowana metoda płatności
Członek od wrz 29, 2008

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.