Hi

I thought I'd post this here in case my posts here don't get seen;

http://www.smith-consulting.com/Forums/forumid/4/threadid/7799/scope/posts.aspx

We're using SmithCart 4.36 with DNN 5.x and SQL server 2008.

I'm trying to import the example spreadsheet.  It seems to import the product data but the inventory of variants is not being created.

I have also found a bug where if there is a variant group that only has one item in it. i.e. this is a drop down for something like "size" then the SKU for the variant inventory is not passed through to the order.   

For example, the data refers to beds and there is only an option for "queen" size. If I add "double" to the list then the SKU for the inventory is passed through. If I remove it again then the SKU is not passed. Of course, I am updating the inventory every time.

Are you working on fixing these for the latest release?  We need them to work critically and urgently.

thanks

Angus

thanks Kevin,

I understand the issue a little better. However, I still don't understand why your code is unable to work if there is only a single value in the dropdown?  Surely "ddList.SelectedItem.Text" should be collected regardless of whether or not a user chose an option? Why does it depend on an "onChange" event which is what you are implying?  Also, going by the logic that you describe if there are two options in the list and the user leaves the box untouched, then does the event get fired?

If it works when there are two items and the user doesn't choose one then clearly an event is not required.

What need is there to fire an event to get the value?  It makes no sense. Dropdowns are often used to get values from database tables where data changes all the time. Just because there is only one record should not cause the application problems. The application should check the value of the drop down regardless of whether the user clicked on it or not.

I understand that if a product has a variant that does not vary then it ought to be a unique product it itself with the color as part of the description so that might be the way forward. However, another color may be made later that is not currently available. The next import would include this colour. Therefore, it is a variant.

Apart from all this, I am working with your example data!  If you understood the data and the application better you would have delivered test data that worked or raised this issue with us when we supplied that data for you to work with. 

And you still have no answered my question as to why the variant inventories are not being imported.

thanks

Angus

Hi Scott and thanks very much for the patches.

However, we are still NOT able to get the import to work with the above spreadsheet.

Firstly we upgraded the module in the usual way by re-installing over the top.  Then we imported the new spreadsheet.

NO variant inventories created.

Secondly we deleted all the existing products and imported again.

NO variant inventories created.

Finally we removed all the smith modules and checked there we not longer any DB objects left. I am pleased to note that all the DB objects had gone; unlike previous versions of Smith Cart which left dozens of tables and sp's which had to be removed manually.

Then we re-installed from scratch and tested the import again.

NO variant inventories created.

Equally frustrating is that re-imports do NOT seem to be updating the existing products. i.e. when prices or other attributes are changed they are not updated.

Finally, in desperation, we deleted all the products and tried an old spreadsheet of our own which somehow worked!  This spreadsheet has a different structure to the one you have provided above.

So, I can only conclude that you are developing with a different spreadsheet/structure than the one you have listed here.

Can you test the one you have here because it clearly does NOT work.

thanks

Angus

ps: our old spreadsheet that seems to import the variants has the following structure:

oh and I forgot to mention, 

I created a clean new DNN 562 build on local and was able to import the products successfully including variants.

However, I then ran into all the same issues outlined above.

Import works when you do it once on a clean install.

Also, we get this on a test with just one record.

The 'Microsoft.Jet.OleDb.4.0' provider is not registered on the local machine.

SmithCart 4.67.0

MS Server 2008

DNN 6

FIXED:  I changed the App Pool settings to allow 32-bit.

Hi Kevin,

Yes, when we import the variants do not work.  If a unique variant sku is required for every variant option then why isn't there a spot to put that?

1. The sku for the order never gets updated with the variant sku.

Based on the only xls file I could get to work (listed earlier in this thread)  I set the VariantSku.

Can you do this with the import?

1. Add the Tab1, Tab2, Tab3, Tab4 fields

2. Set Minimum order quantity  (the default -1 does not work or else there must be a minimum order amount of $1)

3. Hide quantity by default

4. Require login option

One other thing, we have RequireLogin set and it makes you fill out the registration form to complete your order but the DNN user is never created.  Do we need to configure something additional?

Thanks,
Craig

Hi Craig.

I am sorry to bother you, I have the same issue you had, by trying to import variant sku for each variant:

So, my question for you is how did you set the variant sku? did you jusy added a column in excel format for each variant sku? like column ¨VariantSku1¨ for variant 1, an so on?

If you don´t mind please advise. Thank you.

Gabriel