Can someone answer these questions for me?
After creating the new database, is it necessary to populate it with all of the product ids. It seems to me that the code will not work if the ids are not in the new table.
What is the easiest way to insert all of the ids into the new table. I have about 1200 products already in my database.
thanks
Hi lndlyb4,
Good question. You are correct that if you are not working on a fresh install and so already have products created then you will need to create a record in your new table for each product and also insert whatever default value you wish to use for your additional field. Otherwise when you try to edit a product, your changes to the new field will not be saved as the record does not exist to edit!
This is very easy to do assuming you have some basic knowledge of and access to phpmyadmin.
1. Firstly open phpmyadmin and select your zen database.
2. Then select the SQL tab from the top of the screen to display a box to enter the following sql (note the database and field names are based on my original example):
INSERT products_extra_stuff (products_id, products_colour)
SELECT products_id, 'YOUR_DEFAULT_VALUE_HERE' FROM products
3. Note also that you can just leave the default value as '' rather than enter something if you prefer.
Let me know if that works for you.
G
I change all, included deleted,
in my case, the products has a "real code" ( as I know, the code of the producto is not defined in a regular fields......is it correct ?).
Anyway, my products has code, the name of the field is product_code...
I need to show this code in all the process
When the user see in a list, and when click in one of them.
Please, check the images..
what can I do...?
where can I find all the files and vars to know more about it.... ?
Please, check the images
Please, help me.....please.
Regards and forget my "bad english"
Thanks
Hola buitrago,
Yo puedo hablar un poco de español si ayuda.
Ya hay un 'field' (campo?) para "products model" en la parte inferior de la página para agregar / editar los productos. ¿Puedes usar esto?
No, webeo, thaks for u'r spanish.
Model es MODELO, caracteristica qeu provee el fabricante.
Codigo es el ID por el cual las tiendas clasifican su producto.
Ya logre incluirlo, ahora necesito visualizarlo. En la Admin, sale, lo edito, pero no lo logro visualizar.
Tal vez si alguien me especifica donde encontrar los archivos donde se visualiza.
---------------------------------------------------------------
No
"model field" is a self field of product, provided by the "marc". For example
PC : HP.
Model: XP-001
In this case, the "CODE" is a ID using only in a store.
Regards and gracias por tu español.
for lndlyb4
I work with a 12 mil productos, all with an extrafield..
Of course, one day of work, step by step.
product
product descriptions
product extrafield
big work, if u need some hep, please, contact me.
Regards
¿es posible que hayas el mismo problema que lndlyb4?
¿Has seguido las instrucciones que he dado a lndlyb4 en puesto 43 aquí para agregar un valor predeterminado para el nuevo 'field' a todos sus productos existentes?
---------------------------------
Is it possible that you have the same problem as lndlyb4?
Have you followed the instructions I have given lndlyb4 in post 43 here to add a default value for the new field to all your existing products?
Last edited by webego; 26 Sep 2009 at 04:45 PM.
Hi All!!!!!
I upload my these updated files. So when I uploading main_template_vars.php, so it give me error, as my main image is not showing , please look the linkhttp://www.bestlaminate.net/index.php?main_page=product_info&cPath=106_108_134&products_id=359
Please urgent anybody help me .
Thanks
As according to my above post !!!!!!
i think all the problem is to main_template_vars.php
and my there edited code is there . so please let me what i am missing there.
$sql = "select p.products_id, pd.products_name,
pd.products_description, p.products_model,
p.products_quantity, p.products_image,
pd.products_url, p.products_price,
p.products_tax_class_id, p.products_date_added,
p.products_date_available, p.manufacturers_id, p.products_quantity,
p.products_weight, p.products_priced_by_attribute, p.product_is_free,
p.products_qty_box_status,
p.products_quantity_order_max,
pdex.products_box_size,
p.products_discount_type, p.products_discount_type_from, p.products_sort_order, p.products_price_sorter
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_EXTRA_STUFF . " pdex
where p.products_status = '1'
and p.products_id = '" . (int)$_GET['products_id'] . "'
and pd.products_id = p.products_id
and pdex.products_id = p.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
Thanks
In Advance
Bookmarks