Anyone familiar with CSV imports for Landed cost t...
# generals
Sergio
09/22/2020, 6:51 PMAnyone familiar with CSV imports for Landed cost template mapping?
s
sam1128
09/22/2020, 6:52 PMYes what help you need.
s
Sergio
09/22/2020, 6:55 PMNot sure how the mapping is supposed to work
Sergio
09/22/2020, 6:56 PMim mapping it like this,
Sergio
09/22/2020, 6:56 PMCSV Item Internal Id : Item
Sergio
09/22/2020, 6:56 PMand
Sergio
09/22/2020, 6:56 PMLanded cost template internal ID to : internal Id
s
sam1128
09/22/2020, 6:57 PM1. create estimated landed cost template
1. Attach estimate landed cost templates to item record by csv import
s
Sergio
09/22/2020, 7:05 PMyeah, but the mapping at the import is where im getting errors
Sergio
09/22/2020, 7:05 PMI already have landed cost templates created
Sergio
09/22/2020, 7:05 PMbut im not able to update them
s
sam1128
09/22/2020, 7:08 PMYou only need landed cost template internal ID plus item internal ID to create mapping. If you are updating them then you need mapping internal ID as well. Make sure you don’t name all three as internal ID.
s
Sergio
09/22/2020, 7:14 PMOk Im missing one then
Sergio
09/22/2020, 7:14 PMthis is how it looks right now
Sergio
09/22/2020, 7:14 PMmessage has been deleted
Sergio
09/22/2020, 7:15 PMim missing Mapping internal Id then
s
sam1128
09/22/2020, 7:15 PMYes
s
Sergio
09/22/2020, 7:19 PMhow do I find that?
Sergio
09/22/2020, 7:21 PMOk, I found the Landed Cost Template Mapping List
Sergio
09/22/2020, 7:45 PMfrom what I understand, its not possible to clear all the sublist under the items then
Sergio
09/22/2020, 7:45 PMit will write over every mapping ID
Sergio
09/22/2020, 7:46 PMBasically we want to:
1)delete all the landed cost templates for certain SKUS
2) Add a new landed cost template to those skus
s
sam1128
09/22/2020, 8:18 PMYou can have more then one template linked to SKU. Would that help and set new one as preferred one.
41 Views