Magento Configurable Product is a real finding for both customer as well as store owner. If the product is configurable, it means that the customer can make his purchase more personalized and adapt it according to his needs and requirements by choosing from a list of options available, such as size or color etc. EMagicOne company offers smart and convenient solutions for e-commerce. Our unique tools are worth investment, since they are designed specially for those people who value their time and work. We are happy to provide the most efficient and quickest ways of maintaining your online business, which is an integral part of your daily work.
Store Manager for Magento Enterprise Edition is Windows application for easier database management, targeted at the most advanced and large-sized Magento-based stores, offering Enterprise capabilities needed to succeed.The application includes the most comprehensive set of features, management tools and technical support to achieve the highest levels of flexibility, security and automation. Functionality:.
Support of Magento Enterprise as latest versions Magento platform released. Ability to manage multiple Magento stores from one place. Easy product navigation, quick search, advanced built-in and custom filters. Import from the files of CSV, XML, XLS, XLSX, TXT and ODS formats.
Upload of the file with one million lines supported. Import of all product types, custom options, attribute sets, categories, customers. Advanced category, product, attribute management. Mass product and inventory updates using multi-editors. Quick configurable product generation. Ability to change products type of attribute set. Multi-store support.
Fast order creation with POS (one-page order creation), supporting barcode scanner. Ability to create custom reportsEnterprise Edition of Store Manager is geared towards larger companies focusing on the richer and more advanced functionality. It brings key features tailored specifically to accommodate the needs of demanding owners of Magento Enterprise stores.
Shopping cart is considered to be one of the most feature-rich and at the same time most complex eCommerce platforms. Due to this fact, it is natural that databases are usually massive and contain considerable amount of items.
So it is vitally necessary to decrease time required for huge data sets management. For that very reason Magento import has been worked out.Magento import from.csv is definitely positive option for bulk products upload and mass changes implementation, though lots of users report that they have issues uploading files using it. Imported CSV files must meet a number of specific requirements to be accepted. To be brought up correctly to Magento, the spreadsheet should include predefined fields with specified values. The names of columns should be exactly the same as database names, otherwise the system might not recognize the row and skip it or return the error.
Additionally, remember that Magento supports.csv format only and in order for the file to be parsed properly, save it using UTF-8 encoding.Here is the list of files with correct names that need to be in your file for Magento import to be successful. Remember, that first are specified the exact field names that should be used while import with underbars and no capital letters (used identical ones, do not change them.
There is also an explanation for each field and example of possible values to be inputted. Fields without which the product will not be created:Without the following fields the product won’t be imported -. typeid - this field should contain the information that specifies to which type the product belongs, in other words if it is one component or complex. Here should be specified: simple, configurable, virtual, downloadable, grouped or bundle value.
Note that it is case-sensitive and values should not be capitalized. attributeset - here should be the name of attribute set to which products will be assigned. If you did not create any new attribute set, indicate - Default (field is also case sensitive).
Otherwise put the name of attribute set exactly the same as you created. You can find it in Admin Catalog Attributes Manage Attribute Set. taxclassid - put here tax title if you sell taxable goods. If not, use “0”. weight - it is required to indicate the value for weight as it is used to calculate shipping cost.
Use 0 as no value. sku - the unique alphanumeric identifier that you need to track this product and its quantity in your inventory system. It should contain no more than 64 symbols and shouldn’t include special characters or capital letters. Use 0-9 and a-z for sku.
name - full product’s name that will be used by your client for product selection. No specific requirements for this field except that is shouldn’t be empty. price - the value the product is on sale for and for which it can be obtained by the shopper. No specific requirements for this field except that is shouldn’t be empty. description - should contain the information that advertises item and will help client learn about the product. No specific requirements for this field except that is shouldn’t be empty. shortdescription - more concise description of the product that customers will immediately see viewing the product description page.
No specific requirements for this field except that is shouldn’t be empty.The fields responsible for product representation at the front-endWithout the following fields even if the product will be created at Magento database, it won’t be visible from clients’ side:. visibility - defines whether this product is visible from the catalog, search, both or neither. For clients to be able to find the goods at your store use either value 3 for Search or 4 for Catalog, Search visibility. If needed, you can indicate 1 for Not visible individually - it can be used for configurable, grouped or bundle products that shouldn’t be ordered separately. 2 stands for Catalog view only, so products won’t be shown in Magento search results.
rootcategory - indicate main root category of your store. If you haven’t made any modifications to your root category, indicate - Default Category. category - in this field put the category path in case you have multi-leveled categories and make sure that they are divided by slash separator like Hardware/Memory Cards. Field is case sensitive so in case you have Hardware category in your site and indicate here hardware, you will have duplicated categories. All mentioned is related to Magento versions 1.4+.
Older versions use categoryids field. productwebsites - indicate to which website the product will be placed. Use base to add default values. status - you can set it to disabled and depending on this, the product will or will not be available for sale in our store. If set to disabled, the product will not appear in your catalog. Put 1 for enabled, 2 for disabled.
qty - required to be more than 0 in order to show your products if you enabled manage stock option in the administration area. isinstock - 1 value means that the product is in stock and 0 stands for out of stock.Fields that correspond to attributes you created and made as requiredCustom attributes are any attributes that you created yourself and indicated as required (and assigned to particular types of products) become obligatory for your products creation. Check for required attributes in Catalog Attributes Manage Attributes and make sure that they are assigned in Catalog Attributes Attribute Sets (find the attribute that corresponds to your new products) before you start importAdditional fields (optional)Other fields are not obligatory and you can add them if you wish. One of such non-obligatory fields are images, though they are needed for more positive general look of your products.Before the import put image files in media/import and in the.csv file enter the image name prepended with a slash.
You can use the same image for base, small, thumbnail images and media gallery. For that fill in the appropriate fields - image, smallimage, thumbnail, mediagallery.How to avoid the necessity to include all the mentioned above fields?If you expect that you can export the data to the file and have an example or can use the same file for import, you are mistaken. Often the file you just exported won’t be suitable for Magento import so you will need to go through all the above requirements to check why your file is not accepted.