How do I find this data in the database?

[fendy]

I was checking the products_description table and the url column is empty


are the urls stored somewhere else?

[gjh42]

The URL column is for remote manufacturer/product data links (if you have any), not for your site's product URL. Which are you looking for?

[fendy]

The URL column is for remote manufacturer/product data links, not for your site's product URL. Which are you looking for?

i look for the urls of the product in the browser url bar

for example

domain.com/red-nose-deer.html

red-nose-deer.html is what I am looking for

[gjh42]

The URL for your product is built dynamically when it is needed, not stored anywhere.
If you have an SEO mod that rewrites the URL, you will have to ask its author how to find it.

[fendy]

Thanky ou for that answer.

What about the usernames? I checked all the users tables and I could not find it. Zencart does not use usernames for users to log in, do users use only email and password?

[gjh42]

That's right, the e-mail address is effectively the username.

[fendy]

what about the home address of customers?

I can't find it in the customers table?

I am seeing this in customer table

customers_default_address_id

is this where the adress is stored and in which table is full adress?

[gilby]

what about the home address of customers?

I can't find it in the customers table?

I am seeing this in customer table

customers_default_address_id

is this where the adress is stored and in which table is full adress?

What are you trying to achieve going thru all the database tables like this?

Try here: database schema

[fendy]

Thank you for this link, the only puzzle in my database is this

products_options_values_name need to connect with products_id

products_options_values_name are for example

wood, metal, plastic, glass

I connected together
products_options_id
products_options_values_id
products_options_values_name


but I need to connect that to product id, and I dont know why

My main product table in mysql has for each product product_id, so I need to connect this somehow to put everything in excel

[fendy]

puzzle in my database is this

products_options_values_name need to connect with products_id

products_options_values_name are for example

wood, metal, plastic, glass

I connected together
products_options_id
products_options_values_id
products_options_values_name


but I need to connect that to product id, and I dont know why

My main product table in mysql has for each product product_id, so I need to connect this somehow to put everything in excel