on 09-30-2008 8:57 PM
I successfully imported customers with 1 ship to address.
The client now has more address to add to these customers.
Most customers I only attempted to add 1 additional address using line num 0 . These update fine leaving my original ship to address alone.
The customers where I am attempting to update 2 or more new address I have the problem. Again I start my address at line num 0 and increment from there.
When I look at those customers after updating the Ship to address I first imported is gone and is partially over written with the new address.
Thoughts?
The number of ship to addresses are accumulative. Which means, when you DTW the 2nd or 3rd etc, you should not start with 0 but with line# 1, 2, ...
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jared,
When you build your import file, do not forget about Ship-to Default field. You may have 2 or more shipping addresses, that will be stored in the same table CRD1 and only the way to separate them is by using different Address Name.
Therefore you file should look like this:
BP CODE Ship-to Default Ship-to Block Ship-to street
301501 ship 1 29 Kennedy
301501 ship 2 89 Sofocleous
BR,
Marina.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jared,
I am not sure of you really need LineNum to be filled. The AddressName is what is the Key field.
If your AddressName is different that the previous one you imported then you should be fine.
Just fill RecoardKey, AddressName, ..
Please backup your database before trying.
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.