Hi, I am trying to import multiple price levels on...
# csvimportsn
Noel B
10/07/2021, 10:46 PMHi, I am trying to import multiple price levels on our item records. We are successful in updating all but one Price Level. We don't get an error stating it is an invalid name, or an errors at all. The job status page says it is successful, but nothing changes on the item record. The item record under system information shows nothing has changed or the CSV upload happened on the item record. Any idea what might be causing this?
k
KevinJ of Kansas
10/08/2021, 4:46 AMIs it a dynamic price level that's always x percent off base?
n
Noel B
10/08/2021, 2:23 PMNo, it is the field Base Price, but we renamed it to A - Master Cart Price. Last night we renamed the field to remove the "a" from cart. When we did that and did the upload it worked. We then reverted back the change to the correct spelling of "cart" and it again didn't work on the upload.
k
KevinJ of Kansas
10/08/2021, 2:24 PMI would think the hyphen is getting you in this case.
KevinJ of Kansas
10/08/2021, 2:24 PMnot a big fan of special characters in things.
n
Noel B
10/08/2021, 2:25 PMBut, it went from "A - Master Cart Price" to "A - Master Crt Price." Neither the first A or the hyphen was removed.
k
KevinJ of Kansas
10/08/2021, 2:26 PMMaybe there's a hidden 20 character limit?
n
Noel B
10/08/2021, 2:26 PMAh. That is a great thought.
k
KevinJ of Kansas
10/08/2021, 2:26 PMDid any names with longer text work?
n
Noel B
10/08/2021, 2:27 PMActually yeah, "A - Master Display Price", worked just fine.
k
KevinJ of Kansas
10/08/2021, 2:27 PMAny inactive price levels with the first name?
n
Noel B
10/08/2021, 2:27 PMI'll check and see.
k
KevinJ of Kansas
10/08/2021, 2:27 PMCan't think of any reason changing the spelling would impact it other than that.
KevinJ of Kansas
10/08/2021, 2:28 PMbecomes semi-ambiguous so NS just picks the one with the lowest internal ID.
KevinJ of Kansas
10/08/2021, 2:28 PMThat's probably a defect, but good luck getting NS to recognize that one as anything other than U6 if I'm right.
KevinJ of Kansas
10/08/2021, 2:29 PMEspecially because if there is an inactive one with that name and you rename that one to something that'll never get messed with - it might fix issue.
n
Noel B
10/08/2021, 2:31 PMThank you so much. We do have the same name as set to inactive. We will rename the inactive one and see if that does the trick.