Few more details will be helpful
to make everybody understand
how to implement your suggestions.
I have taken the liberty to add in red the action path
(correct me, if wrong)
and a couple of my questions
srdk - 16 November 2007 01:47 PM
In the Magento admin back-end
click on system | import/export | profiles | add new profile
- Add Field Mapping with fixed values, like:
sku => column4
status => “Enabled”
visibility => “Catalog, Search”
price => column10
Columns’ numbers are fixed, as you write them here, or
should be actuals from one’s own custom DB mapping?
- Add conditionally import:
column7 => “Y”
- Add limit/split import for big files:
lines xxx to yyy, commit/pause, lines yyy to zzz, commit/pause, etc…
Where *to add*?
- Unzip file
Unzip? What?
Sorry if these are dumb questions by a non-programmer ,
but I thought it could be useful for all
if this was a bit more clear in its details.
Also: what is the purpose/advantage
in modifying/adding the above code?
In the Magento admin back-end
click on system | import/export | profiles | add new profile
- Add Field Mapping with fixed values, like:
sku => column4
status => “Enabled”
visibility => “Catalog, Search”
price => column10
Columns’ numbers are fixed, as you write them here, or
should be actuals from one’s own custom DB mapping?
Actually i use “Field Mapping” for getting my csv values (column4, column10).
But i would like also to use fixed values that are not in my csv file ("Enabled", etc).
- Add conditionally import:
column7 => “Y”
- Add limit/split import for big files:
lines xxx to yyy, commit/pause, lines yyy to zzz, commit/pause, etc…
Where *to add*?
Below “Field Mapping” frame, in a “Advanced” one for example.
- Unzip file
Unzip? What?
system > import/export > profiles > add new profile
in “File Information”
(with “remote ftp” i can connect to my supplier’s ftp, but the csv price list file is compressed)
Hello my friend Bill has built a solution. He currently has a Price file update and a Stock file update. These updates go out to Ingram download the file and execute the up date. This update takes approximately 30 seconds to complete. We also have integrated full Etilize integration for all your product details and images.
Additionally he has built the Order XML, RMA, and Shipping integration into your Magento install.