Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreWhat are the store tables and stored proceduresWhat are the store tables and stored procedures
Previous
 
Next
New Post
12/28/2007 2:01 PM
 

Hi all

I just installed DNN 4.8 on my pc.  I created few items on using the store.

1. How would I find which version of store module is installed?

2. What tables (name of the tables) Store module uses to keep  products and order information?

3. List of stored procedures used by Store module please.

Thanks Ray

 
New Post
12/28/2007 2:32 PM
 

1) Under the Host menu, choose Module Definitions.  Find Store in the list, and the version will be in the right column.

2 & 3) The tables and stored procedures are all that start with Store_.  You can run a query in the SQL analyzer to find all of the names:

select name from sysobjects where name like '%store_%' order by xtype

When I run that (on my database with the objectQualifier "dnn_"), the tables and stored procedures are:

STORED PROCEDURES

dnn_Store_CartItems_AddItem
dnn_Store_CartItems_DeleteItem
dnn_Store_CartItems_DeleteItems
dnn_Store_CartItems_GetItem
dnn_Store_CartItems_GetItems
dnn_Store_CartItems_UpdateItem
dnn_Store_Reviews_AddReview
dnn_Store_Reviews_DeleteReview
dnn_Store_Reviews_GetAll
dnn_Store_Reviews_GetByProduct
dnn_Store_Reviews_GetReview
dnn_Store_Reviews_UpdateReview
dnn_Store_ShippingRates_AddShippingRate
dnn_Store_ShippingRates_DeleteShippingRate
dnn_Store_ShippingRates_GetShippingRate
dnn_Store_ShippingRates_GetShippingRates
dnn_Store_ShippingRates_UpdateShippingRate
dnn_Store_Administration_AddStoreInfo
dnn_Store_Administration_GetShippingFee
dnn_Store_Administration_GetStoreInfo
dnn_Store_Administration_GetTaxRates
dnn_Store_Administration_UpdateShippingFee
dnn_Store_Administration_UpdateStoreInfo
dnn_Store_Administration_UpdateTaxRates
dnn_Store_Addresses_AddAddress
dnn_Store_Addresses_DeleteAddress
dnn_Store_Addresses_DeleteUserAddresses
dnn_Store_Addresses_GetAddress
dnn_Store_Addresses_GetUserAddresses
dnn_Store_Addresses_UpdateAddress
dnn_Store_Cart_AddCart
dnn_Store_Cart_DeleteCart
dnn_Store_Cart_GetCart
dnn_Store_Cart_PurgeCarts
dnn_Store_Cart_UpdateCart
dnn_Store_Categories_AddCategory
dnn_Store_Categories_CountAll
dnn_Store_Categories_DeleteAll
dnn_Store_Categories_DeleteCategory
dnn_Store_Categories_GetAll
dnn_Store_Categories_GetCategory
dnn_Store_Categories_UpdateCategory
dnn_Store_Orders_CreateOrder
dnn_Store_Orders_GetCustomerOrders
dnn_Store_Orders_GetCustomers
dnn_Store_Orders_GetOrder
dnn_Store_Orders_GetOrderDetails
dnn_Store_Orders_GetOrdersByStatusID
dnn_Store_Orders_GetOrderStatuses
dnn_Store_Orders_UpdateOrder
dnn_Store_Orders_UpdateOrderDetails
dnn_Store_Products_AddProduct
dnn_Store_Products_CountCategoryProducts
dnn_Store_Products_CountPortalProducts
dnn_Store_Products_DeleteCategoryProducts
dnn_Store_Products_DeletePortalProducts
dnn_Store_Products_DeleteProduct
dnn_Store_Products_GetFeaturedProducts
dnn_Store_Products_GetNewProducts
dnn_Store_Products_GetPopularProducts
dnn_Store_Products_GetPortalAllProducts
dnn_Store_Products_GetPortalFeaturedProducts
dnn_Store_Products_GetPortalNewProducts
dnn_Store_Products_GetPortalPopularProducts
dnn_Store_Products_GetPortalProducts
dnn_Store_Products_GetProduct
dnn_Store_Products_GetProducts
dnn_Store_Products_UpdateProduct

TABLES

dnn_Store_ShippingRates
dnn_Store_Categories
dnn_Store_Reviews
dnn_Store_OrderStatus
dnn_Store_Products
dnn_Store_OrderDetails
dnn_Store_Orders
dnn_Store_CartItems
dnn_Store_Administration
dnn_Store_Cart
dnn_Store_Addresses

Hope that helps,


Brian Dukes
Engage Software
St. Louis, MO
866-907-4002
DNN partner specializing in custom, enterprise DNN development.
 
New Post
12/28/2007 5:19 PM
 

Thanks Brian

This is greate But,

When I go to my  SQL Sever Enterprise Manager > (Local)> DataBases > DotNetNuke > Tables  All I see are the system tables. 

How would I access user tables ?   I need to be able to see all the tables that DNN use.

Ray

 
New Post
12/29/2007 10:55 AM
 

Hi Ray,

Connect to your database with the account infos you entered in the web.config file (connectionstring) or with a database admin account .

Gilles


We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.
 
New Post
12/30/2007 3:07 PM
 

Thanks

I rebuild the whole thng all over and fllowed the procedure at  following link and all are fine now.

http://support.microsoft.com/kb/305711

Ray

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreWhat are the store tables and stored proceduresWhat are the store tables and stored procedures


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out