WebSite X5Help Center

 
Sinisa B.
Sinisa B.
User

TABLE PREFIX NAME  en

Author: Sinisa B.
Visited 2085, Followers 1, Shared 0  

Hi,

I'm trying to set-up a database (orders management) and I'm not sure what to put in the field TABLE PREFIX NAME? (pls. see the att.)?

Is this something I must manually create in the MySQL database or the program will automatically create it for me?

Thank you in advance for replying!

Posted on the
9 ANSWERS - 1 USEFUL
Paul M.
Paul M.
Moderator

Hello Sinisa,

You can name the table anything you like, although you must not use spaces in the name.  You might like to choose something which will help you remember what the table is for (i.e. ecommerce/shopping cart).  Alternatively you can leave the field blank, as it is an optional field.

WebSite X5 will create the table for you automatically, and in fact you must specifically let it do so otherwise you will encounter problems later on.

Ref: https://help.websitex5.com/en/v2019.2/pro/index.html?carrello_prodotti_tab4.htm

Kind regards,

Paul

Search the WebSite X5 Help Center (multilingual)

Read more
Posted on the from Paul M.
Sinisa B.
Sinisa B.
User
Author

@ Paul - as always - your comments are spot-on - thank you!

***

BTW - could you direct me to the HELP page where I can find instructions on how to set-up that the (future) buyer could see her/his purchase history (purchased products, orders etc).

Is this even possible with X5 Pro?

Thank you!

Read more
Posted on the from Sinisa B.
Paul M.
Paul M.
Moderator

At the moment only the website administrator has access to order information of that nature, through the online control panel and/or the WebSite X5 Manager app:

https://help.websitex5.com/en/v2019.2/pro/index.html?cart_order_ht.htm

It is possible, however, to send all order information to a MySQL database (in the Pro edition):

https://help.websitex5.com/en/v2019.2/pro/index.html?carrello_prodotti_tab4.htm

If this were done then the Database Viewer Object could be used to retrieve order information from the database:

https://market.websitex5.com/en/objects/live-preview/371262fa-27c5-421a-9127-852da219d4

However, custom code would likely be preferred in most cases as the Database Viewer Object doesn't currently allow sufficient control over precisely what data is displayed and what remains hidden.

Read more
Posted on the from Paul M.
Sinisa B.
Sinisa B.
User
Author

@ Paul -thank you!

So, at least the web shop ADMIN could see the orders online via PC or smartphone...

Paul, what is the difference between the online control panel and the Database Viewer Object (DVO)?

Database Viewer Object data could be seen by the web-shop customers or the web-shop admin (or both)?

If the DVO could be seen by the customers - can it be "set-up" in a way so that the customer A could only see customer's A data and no other?

Thank you in advance for the clarification!





Read more
Posted on the from Sinisa B.
Incomedia
Stefano G.
Incomedia

Hi Sinisa

I'll try to address your question in the best way possible:

1_ What is the difference between the online control panel and the Database Viewer Object (DVO)?

The Online control panel is only accessible through the Admin credentials given inside the software and features a series of additional control for orders and such available to the admins only.

The DVO allows you to specify a table in the database and shows the data contained inside the table in the page you choose to insert the Object into.

As you can see, they have very different purposes

2_ Database Viewer Object data could be seen by the web-shop customers or the web-shop admin (or both)?

That is correct. It is a but a table displaying all the data from one of the database's tables in a specific page.

3_ If the DVO could be seen by the customers - can it be "set-up" in a way so that the customer A could only see customer's A data and no other?

Unfortunately, no. That is not what the Object was designed to do. Additionally, no information apart from the cart orders is saved inside the Database, which would make this functionality useless. No data is strictly connected to a user except for its cart data and order history. However, you can already display User A's orders to User A only through the User Order Object

I hope I've been helpful

Stefano

Read more
Posted on the from Stefano G.
Paul M.
Paul M.
Moderator

Sinisa,

I completely apologise...  the Object Stefano refers to was the one that I should have pointed you directly to in the first place, and should do all that you originally requested:

https://market.websitex5.com/en/objects/data_visualization

@ Stefano, thank you very much for pointing this out: I was not aware of this new Object.  embarassed

Once again, my apologies.

Read more
Posted on the from Paul M.
Sinisa B.
Sinisa B.
User
Author

@ Stefano

Thank you very much for the clarification.

This USER ORDER OJECT is what I meant - it's great that the program is capable of showing that.

BTW - if I put it on a protected page - will the buyer (using her/his user name and password) see only her/his orders? Meaning, the USER ORDER OBJECT will only show the order details of that particular buyer? 


@ Paul


No problem, man - thank you again for your time!

Read more
Posted on the from Sinisa B.
Incomedia
Stefano G.
Incomedia

Hi Sinisa

Yes, that is correct. The Object only displays the data for the currently logged-in user. For this reason, it is best placed behind a Reserved Access page

I hope I've been helpful

Stefano

Read more
Posted on the from Stefano G.
Sinisa B.
Sinisa B.
User
Author

@Stefano

Thank you!

Read more
Posted on the from Sinisa B.