TABLE PREFIX NAME
Autor: Sinisa B.
Visitado 2019,
Followers 1,
Compartido 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!
Publicado en
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)
Autor
@ 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!
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.
Autor
@ 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!
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
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.
Once again, my apologies.
Autor
@ 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!
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
Autor
@Stefano
Thank you!