Forum

The forum is a free service supported by community members. Please consider opening a support ticket if you need timely help.

PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 17 Mar 2011 03:54 PM by  Steve L
BasePrice' does not belong to table
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages


New Member


Posts:
New Member


--
15 Mar 2011 08:50 PM
    Hi,
    I'm getting the following error when trying to import a product:

    Column 'BasePrice' does not belong to table .
    DotNetNuke.Services.Exceptions.ModuleLoadException: Column 'BasePrice' does not belong to table . ---> System.ArgumentException: Column 'BasePrice' does not belong to table . at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at Revindex.Dnn.RevindexStorefront.ProductControl.Fe94VT3G98rMXYqIYyt(Object , Object ) at Revindex.Dnn.RevindexStorefront.ProductControl.ImportButton_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---


    I tried adding manually the Base Price column on the csv files without success (the format is decimal), I tried to see if I could export my products to see if I could get a correct csv file, but there's no export button anywhere (only in categories)... I don't know what could be causing this problem, I already googled and it says to add the mentioned column on the table, but it's not working here.. What could be causing this problem?? the files I used to import where the cvs files available on your site, I wanted to make sure the import feature was working properly and I know this error must be something pretty trivial.

    Thanks in advance and hope to hear from you soon!
    0


    Veteran Member


    Posts:2956
    Veteran Member


    --
    15 Mar 2011 08:58 PM
    Hi,

    If you're running v2.0+, please use the "BasePrice" column. For version below 2.0, please use the "Price" column in your csv. We renamed this column in 2.0 to support price modifiers. It's documented in the Release Notes and Users Manual.

    Thanks!
    0


    New Member


    Posts:
    New Member


    --
    17 Mar 2011 03:19 PM
    Hi

    There was an error in the csv file not being saved, I had to use BasePrice, saved and after it showed me another error: Depth.. I added Depth and now it shows me a different error:

    Invalid import file format. Object cannot be cast from DBNull to other types;

    I believe it's the csv file, however no compatibility issues were shown, so I'm not sure, is there anyway I could get some fresh csv? Also, I tried exporting products in order to get a new csv directly from the website but there's no export option anywhere! (just the import option is there).. how could I fix this? it's error after error after error..

    Thanks in advance
    0


    Veteran Member


    Posts:2956
    Veteran Member


    --
    17 Mar 2011 03:54 PM
    Hi Gustavo,

    I apologize for the left out column in the sample files. We just updated it. The sample files are good for v2.0+ but officially you should always follow the column formats documented in the Users Manual.

    Can you please download the sample CSV files again? Make sure you're running v2.0 and these new sample files should work.
    0
    You are not authorized to post a reply.