La communauté d'échanges francophone Bienvenue, Invité. Veuillez vous connecter ou vous inscrire.

Connexion avec identifiant et mot de passe
16 Novembre 2019 à 00:09:50 *
Nouvelles: Publicité gratuite !
Cliquer ici
   Accueil   Aide Rechercher Mots clés Identifiez-vous Inscrivez-vous  
Magento import
Pages: [1]   Bas de page
  Envoyer ce fil  |  Imprimer  
Auteur Fil de discussion: Magento import  (Lu 1869 fois) Bookmark and Share
0 Membres et 1 Invité sur ce fil de discussion.
16 Novembre 2019 à 00:09:50

Karma: +0/-0
Hors ligne Hors ligne

Localisation: Varsovie, Pologne
Messages: 22

Voir le profil WWW
« : 30 Janvier 2014 à 14:42:15 »
RépondreRépondre SéparerHaut de page

Our task:
To make the import of the products data from the Excel file quick and easy without the excellent knowledge.
Solution using the practice sample:
We should learn the Excel file with the data carefully. The file contains the information about the product name and the price. The file is formatted by categories. The number of the products is about 4 000.
You can write an algorithm using some library with the open code for the excel files parsing in order to parse the source and take the data, but taking into account that the task is disposable, the most optimistic solution will be to copy the cells data in the notepad (ctrl+c, ctrl+v). As goods are divided into categories, we can’t copy them with one block, that’s why we have to copy them by categories. It will take us 10 seconds, not 5 minutes.
Please, investigate what we have got. We have got the file with the tabs, blank space symbols and other useless things copied from the excel file.
We should use Notepad++ search/replacement with use of the regular expressions for clearing the data in the text file. We should clear the redundant blank spaces and tabs and separate the text data with the delimiter “|”. The data is ready for using.
Somehow, we need to create the file from the ready data in the correct format for the import. We should learn the format.
Then we should log into Magento admin panel and do the export of one product using the standard interface. We need to check what we have got. We have got the file with the following content:


We can see the header of the products parameters at the beginning separated by comma. The products data follows them. The absent parameters are left blank (the next comma is written down there). If a field contains several words with the blank space, the data is quoted. 
The headers line and the data line are divided with the symbol of newline and the carriage return. It can be concluded that the data about every new product begins with a new line.
You should take the cleared data about the products and create the same file for import.
The server with the system can accept files for uploading not more 2Mb. We have a big number of data, so we need to divide them into the several parts, for example, by 500 products in the file. We will use the PHP interpreter for execution of the next code:
$i = 0;
$j = 0;
$products = fopen('products.txt', 'r');
$importHeaders = 'sku,_store,_attribute_set,_type,_category,_product_websites,color,cost,country_of_manufacture,created_at,custom_design,custom_design_from,custom_design_to,custom_layout_update,description,enable_googlecheckout,gallery,gift_message_available,has_options,image,image_label,is_imported,manufacturer,media_gallery,meta_description,meta_keyword,meta_title,minimal_price,msrp,msrp_display_actual_price_type,msrp_enabled,name,news_from_date,news_to_date,options_container,page_layout,price,required_options,short_description,small_image,small_image_label,special_from_date,special_price,special_to_date,status,tax_class_id,thumbnail,thumbnail_label,updated_at,url_key,url_path,visibility,weight,qty,min_qty,use_config_min_qty,is_qty_decimal,backorders,use_config_backorders,min_sale_qty,use_config_min_sale_qty,max_sale_qty,use_config_max_sale_qty,is_in_stock,notify_stock_qty,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,stock_status_changed_auto,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,_links_related_sku,_links_related_position,_links_crosssell_sku,_links_crosssell_position,_links_upsell_sku,_links_upsell_position,_associated_sku,_associated_default_qty,_associated_position,_tier_price_website,_tier_price_customer_group,_tier_price_qty,_tier_price_price,_media_attribute_id,_media_image,_media_lable,_media_position,_media_is_disabled';
while (!feof($products)) {
  if($j == 0) {
    $csv = fopen('import-files/import' . $i . '.csv', 'a');
    fwrite($csv, $importHeaders . "\r\n");
  $buffer = fgets($products, 4096);
  $prodBuf = explode('|', $buffer);
  $sku = 'sku-' . $i;
  $date = date("Y-m-d H:i:s");
  $product = $prodBuf[0];
  $price = str_replace(',', '.', str_replace("\r\n", '', $prodBuf[1]));
  fwrite($csv, $sku . ',,Default,simple,,base,,,,"' . $date . '",,,,,"' . $product . '",1,,,0,,,No,,,,,,,,"Use configuration settings","Use configuration settings"' .
  ',"' . $product . '","' . $date . '",," Block after the information column",,' . $price . '00,0,"' . $product . '",,,,,,1,2,,,"' . $date . '",,,' .
  '4,0.0000,100.0000,0.0000,1,0,0,1,1.0000,1,0.0000,1,1,,1,0,1,0,1,0.0000,1,0,,,,,,,,,,,,,,80,,,1,0' . "\r\n");
  if($j == 500) {
    $j = 0;

The text file data is read out, formatted as needed and the csv files are created. Then we should use the standard mechanism of the Magento import uploading the resulting files.
We can see that we can improve Magento functional with our own things and customizations. One of such tips for export the feed files from Magento to shopping engines is Magento Feed Manager. We are talking about GoMage Feed Pro extension which is one of the best in this sphere of the datafeed creation and uploading of the feed files into the shopping engines such as Google, Amazon, eBay, etc:
Signaler au modérateur   Journalisée

Les extensions moderne pour la Magento e-commerce plate-forme
Mots clés: Magento import  development  Feed Manager  GoMage Feed Pro extension 
Pages: [1]   Haut de page
  Envoyer ce fil  |  Imprimer  
Aller à:  

Sujets en rapport
Titre Démarré par Réponses Vues Dernier message
société d'import-export
Espace publicitaire
chris67600 0 4700 Dernier message 27 Janvier 2010 à 21:02:07
par chris67600
Espace publicitaire
MOUSSA 0 3132 Dernier message 26 Septembre 2011 à 18:50:40
Navigation avancée pour Magento
Espace publicitaire
GoMage 0 1780 Dernier message 20 Janvier 2012 à 11:51:07
par GoMage
Simple solutions pour la publicité sur Magento boutique en ligne
Espace publicitaire
GoMage 0 2246 Dernier message 20 Janvier 2012 à 13:42:51
par GoMage
Neatly developed Magento Ajax Cart is a way to prosperous eCommerce business
GoMage 0 3989 Dernier message 24 Septembre 2013 à 13:33:35
par GoMage
Login Improvement for your Magento stores
GoMage 0 5770 Dernier message 26 Novembre 2013 à 13:20:03
par GoMage
Magento Navigation
Espace publicitaire
GoMage 0 3072 Dernier message 18 Février 2014 à 06:39:15
par GoMage
How to install a custom theme in Magento
Espace publicitaire
GoMage 0 1892 Dernier message 07 Mars 2014 à 12:34:36
par GoMage
Boost your Magento store appearance with SEO enhancement
Espace publicitaire
GoMage 0 2151 Dernier message 27 Mars 2014 à 11:56:42
par GoMage
Magento URL rewrites
Espace publicitaire
GoMage 0 2605 Dernier message 16 Avril 2014 à 11:40:00
par GoMage
eCommerce innovations in the Magento sphere
Espace sites internet
GoMage 0 2043 Dernier message 17 Juin 2014 à 17:31:07
par GoMage
Open Graph Protocol
Espace sites internet
GoMage 1 2380 Dernier message 02 Septembre 2014 à 16:07:26
par cindy
Propulsé par MySQL Propulsé par PHP
Powered by SMF | SMF © 2006-2008, Simple Machines
Twitter Mod created by - a web hosting company
| Sitemap
XHTML 1.0 Transitionnel valide ! CSS valide !