Using the reference number of the wholesaler to sort/export/import

Using the reference number of the wholesaler to sort/export/import

Avatar image
Oct 09, 2014
Jos wrote
I have 3 wholesalers who sell the same product(let's say a ink-cartridge HP C1823D) with the same OEM referencenumber/code.
It's not easy or it's even impossible to get the right price on the right wholesalers product.
Every wholesaler has/use their own reference number, completely different from each other.
That's why it would be easy the use also the column with the wholesale ref.number to import or sort etc...

Please vote...

Thanks...
New
1 vote
Vote
Reply
10 Answers
Avatar image
Oct 09, 2014
Alex Pryshlivskiy agent wrote
Hello Jos!
Let's describe station:
You have 3 wholesalers with 3 CSV files.
Each file with different Ref. number.

You have 1 online store with products (for example printer cartridges)
What's the main idea for you ? To import 3 csv files to new one on store with different Ref. number?
Could you give me example?
3 wholesaler's file with Ref.#
1 store file with products and Ref.#

Avatar image
Oct 10, 2014
Jos wrote
Here is a sample with 3 product(but there are thousnds of them).
The product names are not the same and I could update with ref and productname.
But the product names from 1 wholesaler is acceptable the others I changed them
more understandable names (CARTR changed in Cartridge and CY in Cyaan).
So now you have the problem all EAN and refence are the same except the
wholesaler reference.
Can you please make that as a option.

Image and margin are GREAT new options
CSV and Image(with a error) included

Thanks for reading....
Avatar image
Oct 10, 2014
Alex Pryshlivskiy agent wrote
ok, thanks for detailed explanation Jos.
But the way such option already has been implement in Store Manager
I'm talking about Supplier Reference Import.
In your example - Wholesaler = Supplier. Right ?

In this case this mean you need to add Supplier Name to import products correctly.
Avatar image
Oct 10, 2014
Jos wrote
I'm sorry but I can't find/understand this import, can you make a example please.
Avatar image
Oct 10, 2014
Alex Pryshlivskiy agent wrote
ok . please send me full backup and csv files of suppliers.
I'll try to explain you with help of real files and database.
Please don't publish data here - this is public forum.
Please send me to my work email - kibi@emagicone.com
I'll be able to have a look at your problem on Monday.
Avatar image
Oct 10, 2014
Jos wrote
Thanks...
Avatar image
Oct 13, 2014
Jos wrote
Goodmorning,

The database is too big.
I send you the original csv files by mail.

Avatar image
Oct 13, 2014
Alex Pryshlivskiy agent wrote
Good morning Jos
Thanks. I've got your email. Please check email :-)
Avatar image
Oct 13, 2014
Jos wrote
The back-up is working.
Does not include customers, feature and connections columns (saves a lot of space).
Avatar image
Oct 13, 2014
Alex Pryshlivskiy agent wrote
Please use my work email to contact me to solve the problem.
This is Feature Request section instead of Support forum :-)