Magento Users: Throw Away Your Spreadsheets!

[fusion_text]You’ve been working too hard wrangling with spreadsheets in order to create products and update your Magento store. Well, you can relax now because your spreadsheet nightmare is over!

We have been working day and night here at Venzee to integrate our platform with Magento and we are pleased to announce that it’s now available to all Venzee users! Product creation and updates are going to happen in a flash and with almost no use of spreadsheets. It will be almost as easy as waving a magic wand over it!

Venzee is a brand spanking new data transformation method that will make it possible for Magento merchants to work with some serious speed and without a lot of spreadsheets. In fact, your spreadsheet use is going to see a 99% drop off!

Want to see how it works? Let’s give it a go!

Step 1: On The House Sign Up Here

We’re not going to ask for your credit card information anywhere during this simple, 30-second sign up. You’ll be done in no time and able to start uploading your Source Data to Venzee. For more information watch our very short videos:

How do I import data into Venzee?
How do suppliers share data with their retailers via Venzee?

Step 2: The Magento Template

Ok, you have uploaded your data to Venzee and it will be referred to in the remainder of this blog post as your “Source Data”.

We have created a custom template for the Magento platform and placed it in the Venzee Template Library. You are going to use it to create products that are fully compatible with the Magento platform. However, first we have to go get it! So…let’s head on over to the Template Library and grab the Magento template.

Go to Dynamic Data and click the “Add” button. You’re now in our Template Library. When you spot the Magento template, select it and hit “Next”.

How do I create a template?

Step 3: Using The Magento Template To Make A Dynamic Collection

Ok, it’s time to create a Dynamic Collection. The Dynamic Collection is what you will use when you want to make Magento-ready products from your Source Data.

In order to create a Dynamic Collection you’re going to map your Source Data’s attributes (color, weight, size etc.) to the fields in your Magento template. If the format of your Source Data stays the same you won’t need to do this again. If you get stuck the little “?” is there to help you.

There are some advanced features as well. You can do math, add padding to make more attractive products, and make spec tables.

Click “Generate” when you’re done. Click “Export” and Venzee will send you a download link. Remember, this is the file that you’re going to use to make Magento-ready products.

How do I create a Dynamic Collection?
How do I import images into Venzee?

Step 4: After The Spreadsheet Storm Comes A Calm Called Venzee!

Ok, you did it! You took your Source Data and created a Dynamic Collection from it. Now you can use the Dynamic Collection to quickly whip up dynamic, Magenta-compatible products that will get updated whenever your Source Data gets updated![/fusion_text][tagline_box backgroundcolor=”” shadow=”no” shadowopacity=”0.7" border=”” bordercolor=”” highlightposition=”none” content_alignment=”left” link=”/register?referrer” linktarget=”_self” modal=”” button_size=”large” button_shape=”square” button_type=”flat” buttoncolor=”” button=”Get Started!” title=”Stop losing sleep agonizing over your spreadsheets! Let Venzee handle it!” description=”” margin_top=”” margin_bottom=”20" animation_type=”0" animation_direction=”down” animation_speed=”0.1" animation_offset=”” class=”vz-tagline vz-tagline-blog” id=””][/tagline_box][separator style_type=”none” top_margin=”20" bottom_margin=”” sep_color=”” border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”” alignment=”center” class=”” id=””][content_boxes settings_lvl=”child” layout=”icon-with-title” columns=”2" icon_align=”left” title_size=”” title_color=”” body_color=”” backgroundcolor=”” icon_circle=”” icon_circle_radius=”” iconcolor=”#ffffff” circlecolor=”#83cf49" circlebordercolor=”#ffffff” circlebordersize=”” outercirclebordercolor=”#ffffff” outercirclebordersize=”” icon_size=”” icon_hover_type=”” hover_accent_color=”” link_type=”” link_area=”” link_target=”” animation_delay=”” animation_offset=”” animation_type=”0" animation_direction=”left” animation_speed=”0.1" margin_top=”10" margin_bottom=”-10" class=”” id=””][content_box title=”No-Speed-Limit Inventory Updating” icon=”fa-check” backgroundcolor=”” iconcolor=”” circlecolor=”” circlebordercolor=”” circlebordersize=”” outercirclebordercolor=”” outercirclebordersize=”” iconrotate=”” iconspin=”no” image=”” image_width=”35" image_height=”35" link=”” linktext=”” link_target=”_self” animation_type=”” animation_direction=”” animation_speed=””]Venzee’s no-speed-limit inventory updating zaps those distressing backorders![/content_box][content_box title=”Content Rich Magento Products” icon=”fa-tags” backgroundcolor=”” iconcolor=”” circlecolor=”” circlebordercolor=”” circlebordersize=”” outercirclebordercolor=”” outercirclebordersize=”” iconrotate=”” iconspin=”no” image=”” image_width=”35" image_height=”35" link=”” linktext=”” link_target=”_self” animation_type=”” animation_direction=”” animation_speed=””]Easily turn dry, specifics-packed, supply chain-provided product information into eye-catching, error-free content![/content_box][content_box title=”No-Wait Notifications” icon=”fa-envelope” backgroundcolor=”” iconcolor=”” circlecolor=”” circlebordercolor=”” circlebordersize=”” outercirclebordercolor=”” outercirclebordersize=”” iconrotate=”” iconspin=”no” image=”” image_width=”35" image_height=”35" link=”” linktext=”” link_target=”_self” animation_type=”” animation_direction=”” animation_speed=””]When anyone makes an update — manufacturer, supplier, or team member — you see it right away. Invaluable information that will have you wondering how you ever worked without it.[/content_box][content_box title=”Web-Optimized Graphics” icon=”fa-camera” backgroundcolor=”” iconcolor=”” circlecolor=”” circlebordercolor=”” circlebordersize=”” outercirclebordercolor=”” outercirclebordersize=”” iconrotate=”” iconspin=”no” image=”” image_width=”35" image_height=”35" link=”” linktext=”” link_target=”_self” animation_type=”” animation_direction=”” animation_speed=””]One click turns those monster 2–4 MB high-resolution images your manufacturer or supplier sends you into images that are both custom-sized and web-ready![/content_box][content_box title=”Contact Us 24/7 “ icon=”fa-phone” backgroundcolor=”” iconcolor=”” circlecolor=”” circlebordercolor=”” circlebordersize=”” outercirclebordercolor=”” outercirclebordersize=”” iconrotate=”” iconspin=”no” image=”” image_width=”35" image_height=”35" link=”” linktext=”” link_target=”_self” animation_type=”” animation_direction=”” animation_speed=””]Our Venzee all-stars are old pros when it comes to eCommerce. They are always standing by, ready to help 24/7. Don’t be shy or they’ll feel neglected. Venzee is here to make your life easier. We speak English, French, Mandarin, Spanish, and Portuguese![/content_box][content_box title=”Get Your Suppliers and Manufacturers Involved” icon=”fa-birthday-cake” backgroundcolor=”” iconcolor=”” circlecolor=”” circlebordercolor=”” circlebordersize=”” outercirclebordercolor=”” outercirclebordersize=”” iconrotate=”” iconspin=”no” image=”” image_width=”35" image_height=”35" link=”” linktext=”” link_target=”_self” animation_type=”” animation_direction=”” animation_speed=””]Tell your supply chain that you’re finished with spreadsheets. Done. Finito. They can now share their product information with you for free via Venzee![/content_box][/content_boxes][imageframe lightbox=”no” lightbox_image=”” style_type=”none” hover_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0" stylecolor=”” align=”none” link=”” linktarget=”_self” animation_type=”0" animation_direction=”down” animation_speed=”0.1" animation_offset=”” hide_on_mobile=”no” class=”” id=””]

[/imageframe][testimonials design=”classic” backgroundcolor=”#f9a00e” textcolor=”#ffffff” random=”” class=”” id=””][testimonial name=”” avatar=”none” image=”” image_border_radius=”” company=”” link=”” target=”_self”]Quickly whip up dynamic,Magenta-compatible products that get updated whenever your Source Data gets updated![/testimonial][/testimonials][separator style_type=”none” top_margin=”20" bottom_margin=”” sep_color=”” border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”” alignment=”center” class=”” id=””][fusion_text]About Magento

Started in 2007, Magento is now a leader in eCommerce platforms and offers both an open-source solution and Magento Commerce, a cloud-based solution. With over 200,000 merchants Magento is a true powerhouse handling over $50 billion each year in gross merchandise volume. We’re excited about working with a company that understands what it takes to produce a high-quality shopping experience and we look forward to helping Magento take eCommerce to the next level![/fusion_text]

Like what you read? Give Kate Hiscox a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.