https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hello guys, Can I import data using CSV import in ...
# suitescript
n
Hello guys, Can I import data using CSV import in items Pricing like Alternate Price 1 , Alternate Price 2, etc as shown in the image: Kindly help me here!!
b
probably have a better chance in #CBQ338ZE0
n
Hi @battk, I’m trying to import it using CSV but getting error! is there any setting needs to be done on the account or somewhere?? Can you please help me here? Thanks in Advance!
b
that error is pretty clear
Enter Location
is not a valid location id for the subsidiary with id 6
fair chance its not valid at all
n
I did not entered any location while importing csv
b
thats not with your screenshot says
excel shows a value in the location
🤔 1
n
my sheet only contains Internal ID of item and while setting template I added only Price level 3 fileds! thats it!
b
what does your mapping look like
n
this
Do you find any issue in it?
b
this looks fine
but there should be other mappings
items can have multiple mappings
🤔 1
n
I tried same on another account which has only filed though! on the item! and it got updated
but this Netsuite account item has multiple Item 0 , Item 5, etc price fields!
b
There are multiple way to import items when working with pricing data
n
thanks, I’ll check it out!
b
single files and multiple
im not sure which one you are doing
n
I was uploading single file for only one Alternate Price 1
b
your mapping combined with your error suggests that your location column is mapped
since the mapping you are showing doesnt have the location mapped, you are looking at the wrong mapping
if you are absolutely sure you aren't mapping location, then remove it from your csv
n
I’m not mapping Location in CSV
b
then remove it from your csv file
n
there is no location in my csv file too!
just Internal ID column is there
b
your screenshot from excel said otherwise
n
this is my csv file
b
none of that data matches
n
that’s the reason, I didn’t understand what the error is! since there is no relation of location here
b
which means you are either uploading or running the wrong import
or there are multiple mappings / files
n
This is what error is coming
this is item
see this too
I really don’t understand the issue here!!🤔
b
upload your csv file
n
yeah just tried uploading and got the above error
b
upload it here
n
b
create a new csv import with that file
shouldnt do anything interesting, but netsuite should only map that one column
n
same error
Don’t understand why NS is behaving like this or I’m missing any setting or something!!🤔
please let me know if you find anything! I’ll check it on the url you provided me till then!
b
id guess a workflow or user event script
but those arent supposed to add columns to the results
you can try disabling them in the import settings
n
yeah , I actually disabled that check box
even though I’m getting this error!
How I can even map like this??
I can’t add the fileds after I add for first time!!!
b
its the plus after the 
Item - Pricing
n
okay, I’ll check it
thanks
Open in Slack
PreviousNext
Powered by