Error with Uploading Product Options

[Everwilde]

I upgraded to Shopsite 12 sp2 this week, and am having an issue with my uploads. Since I sell through multiple channels on the web, I need to do inventory tracking in a third party program, and rectify the Shopsite availability a few times per week with a product upload. I am using product options to create a dropdown of the different sizes that our products are available in (Packet, Oz, Lb, etc). So my upload had 3 fields (SKU, Option Select Default, & Product Options (which has 13 submenus). When I went to upload, Shopsite did not recognize the Product Option field, and the only option was to ignore. Now it does not like the upload because it says that there are 13 fields where there should only be 2. Please help, as I cannot update my inventory until this is resolved.

Steve

[Jim]

A link to your site were we can see what a typical set of options is would be helpful.
Post a few rows of your upload file so we can see how you have thing formatted (include the header row).

[Everwilde]

The website is www.everwilde.com and here is the top of the upload:

SKU Option Select Default Product Options
FACHFIL Select the size here . . . !menu1 ##
!menu1 menu2 menu3 menu4 use apptext sku pricemod weightmod qtyonhand lowstock outofstock image
Packet: checked (2000 Seeds) . . . $2.50 FACHFIL-01 2.5 0.51 none ##
1/64 Oz: FACHFIL-02 0.515 none ##
1/16 Oz: checked (1.77g) . . . $4.80 FACHFIL-03 4.8 0.563 none ##
1/4 Oz: checked (7.09g) . . . $6.00 FACHFIL-04 6 0.75 none ##
1 Oz: FACHFIL-05 0 1.5 none ##
1/4 Lb: FACHFIL-06 0 4.75 none ##
1 Lb: FACHFIL-07 0 17 none ##
5 Lb: FACHFIL-08 0 82 none ##
10 Lb: FACHFIL-09 0 164 none ##
!!
FACHMIL Select the size here . . . !menu1 ##
!menu1 menu2 menu3 menu4 use apptext sku pricemod weightmod qtyonhand lowstock outofstock image
Packet: checked (2000 Seeds) . . . $2.50 FACHMIL-01 2.5 0.51 none ##
1/64 Oz: FACHMIL-02 0.515 none ##
1/16 Oz: FACHMIL-03 0.563 none ##
1/4 Oz: checked (7.09g) . . . $4.80 FACHMIL-04 4.8 0.75 none ##
1 Oz: checked (28.4g) . . . $7.20 FACHMIL-05 7.2 1.5 none ##
1/4 Lb: checked (113g) . . . $14.40 FACHMIL-06 14.4 4.75 none ##
1 Lb: FACHMIL-07 0 17 none ##

[Jim]

One thing that I see that looks incorrect, in these lines

Code: Select all

FACHFIL Select the size here . . . !menu1 ##
!menu1 menu2 menu3 menu4 use apptext sku pricemod weightmod qtyonhand lowstock outofstock image


the !menu1 should have a number and colon (:) before the menu1 like this !0:menu1
and the next product should have the number incremented

Code: Select all

SKU Option Select Default Product Options
FACHFIL Select the size here . . . !0:menu1 ##
!0:menu1 menu2 menu3 menu4 use apptext sku pricemod weightmod qtyonhand lowstock outofstock image
Packet: checked (2000 Seeds) . . . $2.50 FACHFIL-01 2.5 0.51 none ##
1/64 Oz: FACHFIL-02 0.515 none ##
...
10 Lb: FACHFIL-09 0 164 none ##
!!
FACHMIL Select the size here . . . !1:menu1 ##
!1:menu1 menu2 menu3 menu4 use apptext sku pricemod weightmod qtyonhand lowstock outofstock image
Packet: checked (2000 Seeds) . . . $2.50 FACHMIL-01 2.5 0.51 none ##
1/64 Oz: FACHMIL-02 0.515 none ##
...
1 Lb: FACHMIL-07 0 17 none ##

Give that a try and see if it works.

[Jim]

Another thing I notice: In the line

Code: Select all

FACHMIL Select the size here . . . !menu1 ##

The FACHMIL is the product sku. So in the example code you posted both products have the same sku. Is that what you wanted?

[Everwilde]

What is really strange is that I have been using this upload template for several years without issues, and this just popped up this week with the V12 sp2 upgrade with Lexiconn. I made the change to the menu:

SKU Option Select Default Product Options
FACHFIL Select the size here . . . !menu1 ##
!0:menu1 menu2 menu3 menu4 use apptext sku pricemod weightmod qtyonhand lowstock outofstock image
Packet: checked (2000 Seeds) . . . $2.50 FACHFIL-01 2.5 0.51 none ##
1/64 Oz: FACHFIL-02 0.515 none ##
1/16 Oz: checked (1.77g) . . . $4.80 FACHFIL-03 4.8 0.563 none ##
1/4 Oz: checked (7.09g) . . . $6.00 FACHFIL-04 6 0.75 none ##
1 Oz: FACHFIL-05 0 1.5 none ##
1/4 Lb: FACHFIL-06 0 4.75 none ##
1 Lb: FACHFIL-07 0 17 none ##
5 Lb: FACHFIL-08 0 82 none ##
10 Lb: FACHFIL-09 0 164 none ##
!!
FACHMIL Select the size here . . . !menu1 ##
!1:menu1 menu2 menu3 menu4 use apptext sku pricemod weightmod qtyonhand lowstock outofstock image
Packet: checked (2000 Seeds) . . . $2.50 FACHMIL-01 2.5 0.51 none ##
1/64 Oz: FACHMIL-02 0.515 none ##
1/16 Oz: FACHMIL-03 0.563 none ##
1/4 Oz: checked (7.09g) . . . $4.80 FACHMIL-04 4.8 0.75 none ##
1 Oz: checked (28.4g) . . . $7.20 FACHMIL-05 7.2 1.5 none ##
1/4 Lb: checked (113g) . . . $14.40 FACHMIL-06 14.4 4.75 none ##
1 Lb: FACHMIL-07 0 17 none ##
5 Lb: FACHMIL-08 0 82 none ##
10 Lb: FACHMIL-09 0 164 none ##
!!

It came back with this error:

"This record has 13 tabs instead of 2. It may be missing some fields. Please correct the problem and reload.
Record name: !1:menu1"

It does not like my "Product Options" field and does not give me any mapping options except ignore. I told it to ignore that field, but then it has this error. The other two fields only have two options in the mapping dropdown - the matching one and ignore. I would expect lists in the dropdowns to map to?

The two SKUs listed are very similar, but differ by one letter.

Thanks for the help!

Steve

[Everwilde]

I also added the !0: to the submenu header, but had the same results. No field mapping options in the dropdown except "ignore".

Steve

[Jim]

FACHFIL Select the size here . . . !menu1 ##
FACHMIL Select the size here . . . !menu1 ##

Both of those are missing the record number and : between the ! and menu1 they should be
FACHFIL Select the size here . . . !0:menu1 ##
FACHMIL Select the size here . . . !1:menu1 ##

As for the message "This record has 13 tabs instead of 2. It may be missing some fields. Please correct the problem and reload.
Record name: !1:menu1"
This is probably the result of an extra blank row after the last line with just !! in it. Make sure that the row with the final !! ends without a return/enter character.

Working with advanced order options can be very difficult in a spreadsheet format. You might want to look at the xml format to see if that is any easier for you.

Lexiconn provides excellent support. Have you asked them for assistance?

If you still can't get it to work send me a copy of your upload file using the email link associated with the forum post.

[Everwilde]

Thanks for your patience with this - I made the changes, and am getting the same error. I will Email you the upload file in a csv format, though I normally upload it in txt. You are right about order options being cumbersome in a spreadsheet - it took a long time for me to come up with the current upload for our products, but not sure how else to do it.

[Everwilde]

Jim,

OK, Emailed you the upload file yesterday, but might have gone into a spam folder or something.

Steve