Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Import Improvement
 
srdk
Jr. Member
 
Total Posts:  4
Joined:  2007-08-31
 

- Add Field Mapping with fixed values, like:

sku => column4
status => “Enabled”
visibility => “Catalog, Search”
price => column10

- 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…

- Unzip file

 
Magento Community Magento Community
Magento Community
Magento Community
 
WisdOMbooks
Sr. Member
 
Avatar
Total Posts:  144
Joined:  2007-08-31
Kolkata (Calcutta) - INDIA
 

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 12: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 red face,
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?

Thank you for your patience rolleyes  .

A n g e l o

 
Magento Community Magento Community
Magento Community
Magento Community
 
srdk
Jr. Member
 
Total Posts:  4
Joined:  2007-08-31
 

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)

 
Magento Community Magento Community
Magento Community
Magento Community
 
WisdOMbooks
Sr. Member
 
Avatar
Total Posts:  144
Joined:  2007-08-31
Kolkata (Calcutta) - INDIA
 

Thank you for the suggestions:
I will give it a try and see.

 
Magento Community Magento Community
Magento Community
Magento Community
 
srdk
Jr. Member
 
Total Posts:  4
Joined:  2007-08-31
 

Any news ?

Import from Ingram Micro requires some of those stuffs.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ashish96
Member
 
Avatar
Total Posts:  63
Joined:  2009-01-21
Gujarat, India
 

@srdk
how to connect with Ingram Micro ‘IMMustang’??
any updates???

 
Magento Community Magento Community
Magento Community
Magento Community
 
jadog
Jr. Member
 
Avatar
Total Posts:  30
Joined:  2009-02-11
California
 

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.

For more info contact him at:

Etilize and Ingram Micro Integration
http://strattas.com/Etilize-Magento.htm
contactus@strattas.com
(310) 809-3454

Demo Websites:
Ingram Micro Magento Integration Demo
SP Richards Magento integration Demo

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top