We work on numerous Magento based websites and in particular diamond and jewelry e-commerce stores. Impressed by powerful features; Magento is the shopping cart of choice for many e-store owners. However after building the Magento shop and customizing its design, we realize that many of these e-shops are unable to go in production or are extensively delayed.
Impressed by powerful features; Magento is the shopping cart of choice for many e-store owners. However after building the Magento shop and customizing its design, we realize that many of these e-shops are unable to go in production or are extensively delayed.
The number one reason for interruption is: botched up product data entry.
While selecting Magento; shop owners don’t realize the complexity of “product data entry”; done manually one by one or through bulk uploads. The ground work to be done for data entry is often overlooked.
If you are planning a Magento store get yourself acquainted with Magento data structure (It doesn’t require programming knowledge). This may include understanding attributes, attribute sets, options, simple products and configurable products etc. Latter, work with your developer on a suitable data entry schema.
Remember that developer alone won’t be able to finalize the data schema; as it requires considerable subject matter expertise. For example for loose Diamonds there are multiple attributes like shape, carat weight, cut, fluorescence etc. or, suppose you are selling Car accessories including Tires you need to supply tire related attributes to developer such as width, rim size, aspect ratio, radial construction details, wet grip rating, noise rating etc. Further you need to work with your developer in finalizing attribute sets /groups and providing him with sample data sheet.
Below is the most suitable data schema for a Diamond Jewelry e-store for ready reference. The data schema is generic and can be customized.
Magento data schema for Diamond Jewelry eCommerce store.
Engagement Ring Settings: Settings are for “Build your ring feature” wherein a buyer can select a diamond and setting combination.
Category Structure provides top level categorization of products. Diamonds are categorized by shape and jewelry and setting by its style.
The above data schema will work good for creating simple products. Based on the same configurable products can be also created.
More info : [email protected]