Stock For Product With Different Attributes (OLD)

audradh:

I have yet to add any modules to my cart. I am working through things as I come to them, but I have a lot to learn about webspace in general, including Zen Cart.

There are plenty of references throughout the forums to "backup before making major changes" and "test this thoroughly before going live."

How do y'all test something before going live? Once in business your website is live 24/7. So where does the testing happen?

Bet ya weren't expecting such a bare basics kinda question :)

The Newbie,
Audra
Have two seperate installs (one on local machine and one on live server)

My orders doesn't show!!! i got the money but it seems like I don't know what da heck they ordered...

I need some help..

I am using 1.2.5d, and i've installed this module correctly and I set up all my products and all, but it doesn't display what they ordered on the admin page.

Please help me ASAP. Thank you.

This was never tested on 1.2.5d...

Anybody care to walk a newbie through their first module install as well as their first trip into MYSQL?

I have downloaded the module, read the read me file and poked around a bit.

So, the first step is to create the table. I have found my way into the database. The prefix on my tables is zen_, so I am good to go.

I have found the place to add a new table. I have figured out that the first line in the read me file is the table name and the subsequent lines are fields. The last line has me confused.

PRIMARY KEY ( stock_id )
)

What is the primary key?

I know, about as basic as it gets! One day I will understand all this :blink:

Audra

OK, I think I figured out the primary key. I have checked the radio button next to stock_id labeled primary. (I even read about primary keys on MYSQL.com although I must admit most of it was lost on me!)

Since I am here rambling I may as well describe the rest of the process as I see it. There must be another newbie out there as lost as I who will benefit!

After creating the table I now need to upload the files provided in the module to the appropriate folders on my server.

Hey, thanks for listening as I talked myself through this!

Audra

Sorry, I guess I do have one sticking point. What is the "Table Type?" I am assuming it is the default, "MyISAM." Is this correct?

Audra

Now I have a question about uploading the files. In

/ admin / includes / languages /

there is a file english.php to upload. Do I overwrite the existing file?

TIA,
Audra

a_berezin:

Better way -- create file admin/includes/boxes/extra_boxes/products_with_attributes_stock_catalog_dhtml.php
Has anyone tried this? I added the file and no new option showed up under catalog. However, I have no idea what I am doing! I copied the php file, pasted it into notepad, saved it as
products_with_attributes_stock_catalog_dhtml.php

then uploaded it to the specified place.

What did I do wrong?

Audra

I just tested this contribution and looks good. But when ordering a variation out of stock, the cart never throws an error or warning message for the customer.

A quantity overview for the customer would be awesome as well. ::tup

I am testing it right now. It allows me to place the item in my shopping cart, but displays a message that the item is out of stock or not available in the quantity ordered. I have configured my cart to not allow checkout for out of stocks. This is working as well.

Audra

masterblaster:

when ordering a variation out of stock, the cart never throws an error or warning message for the customer.
Check your settings under Configuration->Stock perhaps?

audradh:

Has anyone tried this? I added the file and no new option showed up under catalog. However, I have no idea what I am doing! I copied the php file, pasted it into notepad, saved it as
products_with_attributes_stock_catalog_dhtml.php

then uploaded it to the specified place.

What did I do wrong?

Audra
Although I would like to know why the 1st version did not work I did get it working by using da'fonz' edit instead.

Audra

Hello! Thanks for a great contibution! This is something i have been looking for!

I'm very new to zencart, and I don't know a thing about MySQL. I don't know what to do with this code:
[/CODE]
CREATE TABLE zen_products_with_attributes_stock (
stock_id INT NOT NULL AUTO_INCREMENT ,
products_id INT NOT NULL ,
stock_attributes VARCHAR( 255 ) NOT NULL ,
quantity INT NOT NULL ,
PRIMARY KEY ( stock_id )
) [CODE]

Shall i put it in the Admin -> Tools -> Install SQL Patches?

Hope somebody can help me! :blink:

Hey, Taflloyd! The code in the Read Me is what you'll use as a MySQL query. Whatever the website interface you're using, you'll find the section that allows you to administer your site's databases and paste the code into the text field used for MySQL queries. For example, if you use cPanel to administer your website and phpMyAdmin to administer your databases, running the query will add a table to your database with the fields needed to use the module.

a_berezin:

Yes! I use the digit prefix in filenames for that. ;)
How would I do that to put the menu item in position 2 of the Catalog menu instead of the end?

Trying to use overrides with this module, per this thread.

Instead of replacing database_tables.php (which would get overwritten in a ZC upgrade), I'm placing the database define

<?php
 define('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK', DB_PREFIX . 'products_with_attributes_stock');
?>

into /includes/extra_datafiles/products_with_attributes_stock_database_tables.php.

However, I'm getting the error 1146 Table 'cfus_zc1.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist when I use Admin. Any ideas why the /includes/extra_datafiles define isn't being called? When I copied the file to /admin/includes/extra_datafiles it did work.

Rather prolific tonight, I am. What functions from functions_lookups.php do I need to put into an override file (which would go in /includes/functions/extra_functions)?

mrtoner:

Hey, Taflloyd! The code in the Read Me is what you'll use as a MySQL query. Whatever the website interface you're using, you'll find the section that allows you to administer your site's databases and paste the code into the text field used for MySQL queries. For example, if you use cPanel to administer your website and phpMyAdmin to administer your databases, running the query will add a table to your database with the fields needed to use the module.
Hey!
Thanks for your answer!
I use phpMyAdmin, and I found the query window, and paste the code. Selected the database and hit "Go". Nothing happened... What am I doing wrong?

Taflloyd:

I use phpMyAdmin, and I found the query window, and paste the code. Selected the database and hit "Go". Nothing happened... What am I doing wrong?
If you're using phpMyAdmin, in my experience you need to 1) select the database, 2) click the SQL tab, 3) paste the query into the "Run SQL query/queries on database yyy" field, and 4) click "Go." If I'm reading your post correctly, you did two of those steps out of order. (I'm using phpMyAdmin 2.6.4-pl2.)