Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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 ForumsStoreStoreState of art of module StoreState of art of module Store
Previous
 
Next
New Post
2/17/2009 4:53 AM
 

Hi

I have a store designed in OSCommerce and now I wish to trasform in DNN with store module but I've some doubt about this.

First of all I wih know if there's some example of store developed with Store module.

The second question is about the DB of the module. Now I download article, class, description, price etc. from one managerial db and I Upload this information in OSCommerce. Use the same way in DNN is an hard way. Someone make this operation or the manage of article must do in DNN interface?

Finally I wish know if the store module have a roadmap that see to the future or is a module like, for example, gallery, without defined time to develop and release.

 

Thans for your comment.

Alex

 
New Post
2/18/2009 1:02 AM
 

Hi Alex,

I never used OSCommerce, then it's difficult to compares. You have to know that the Store module do not allow variants product. I will add this feature in a future version.

Concerning your upload from another database, it depend if it's a one shot or regular (update, synchro). For a one shot import, you can use the Import feature. Like many other DNN modules, Store use an XML file for import / export products and categories. If you have to update your products on a regular basis, you could write a stored procedure or use a database tool (Enterprise Manager, RedGate, ...)..

Currently, I do not have a roadmap. I have to finish some changes for XHTML compliancy, then after I will write a roadmap for future versions.

Giles


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
2/18/2009 3:16 AM
 

Hi gilles

Thanks for your answer.

I update about more than one time/week I haven't any problem to create a stored or a software for automatic update. I work all day with sqlserver and dotnet.

Actually one o two customer of mine want to migrate theire site on a platform different from OSCommerce and I wish use your module.

My customers, often, use a structure like this 

Category - SubCatecogory - Brand - Product

Do you think is posibile codify a produtct in this way with your module? I

There's a way to know the DB definition used by your module, the field and so on?

Thanks


Alex

 

 

 
New Post
2/18/2009 5:08 AM
 

Hi Alex,

The Store module allow an unlimited number of categories and sub categories. A product is linked to only one category (another limit I have to change in a future version). Concerning the complete fields list, you can install the module on a DNN instance and look for tables names with the prefix 'Store_' like: Store_Categories, Store_Products, ...

Here the Store_Categories fields:

CategoryID int
PortalID int
CategoryName nvarchar 50
CategoryDescription nvarchar 500
Message ntext
Archived bit
CreatedByUser nvarchar 100
CreatedDate datetime
ParentCategoryID int
OrderID int
IsDeleted bit
*CategoryKeywords nvarchar 1000

and the Store_Products fields:

ProductID int
PortalID int
CategoryID in
Manufacturer nvarchar 50
ModelNumber nvarchar 50
ModelName nvarchar 50
ProductImage nvarchar 500
UnitCost money
Summary nvarchar 1000
Description ntext
Featured bit
Archived bit
CreatedByUser nvarchar 100
CreatedDate datetime
ProductWeight decimal
SaleStartDate datetime
SaleEndDate datetime
SalePrice money
IsDeleted bit
ProductHeight decimal
ProductLength decimal
ProductWidth decimal
*Keywords nvarchar 1000
*StockQuantity int
*LowThreshold int
*HighThreshold int
*DeliveryTime int
*PurchasePrice money

Fields wtih * will be included in the next version (02.02.00). Currently there is a beta available but no release date.

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
2/18/2009 7:41 AM
 

Hi Gilles

A category, a subcategory is sufficient, for now. When you'll implement that a product can be associated with more than a category, I'll see how to manage the customer (like a category).

I will see to the structure and try to implement a store on local host.

Many thanks for now.

Alex

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreState of art of module StoreState of art of module Store


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