Case study of Aiya America

Aiya America came to us looking to migrate their three  Magento stores into one BigCommerce store. Requiring a custom built API for storing and displaying their recipies, as well as user friendly templates for their in-house team to create their own pages after we launch.  Aiya had over four thousand customers we needed to migrate, and only 50 products. But the customers were spread throughout three sites with no common Id number.  They also asked for a custom recipe app that would allow our client’s staff to add and manage their recipes through a friendly user interface.  The appcould collate the information into the html needed to display the recipes on the frontend and then post it to the main site backend via the API.

            Working with the client, the design of the site was laid out. Thankfully the client knew its audience and design was laid out rather easily. This migration was primarily a copy of their old site, so the page layouts were not that difficult to copy. However, aiya did request some new pages and new designs.

THE APP:  Our developers started right away on the API considering it was the most time consuming aspect of the scope. Built from scratch, we started working on the framework of the app. The app we designed with the client’s staff in mind, we had to make it with a very simple user interface. Using text boxes, checkboxes, tags, and image loaders, the app would convert the specific recipe information into an html page and append it to the main site via api. The app also includes admin credentials, and a separate domain.

THE MAIN SITE: After clearing the design with the client, the framework for the site was laid out. Creating the pages was not the hard part, but the specifics of some of the designs were very time consuming. The timeline was a 3d carousel slider depicting the dates and milestones of Aiya. This was especially hard to code and took almost a day to get right. Another difficulty was the integration of the app through the API to the front end site. After a week of coding the integration was done and all the recipes were showing up perfectly.

THE MIGRATION: Every project has its obstacles, the migration was the main obstacle of the project. What we thought would only take two days to complete, took almost two weeks. Aiyas old Magento site was split up amongst 3 separate sights. First one was their retail customer database. Second site was their wholesale customer site. The last site was their products site. Both the retail database and the wholesale database had multiple tables with customer information on it. The best analogy of the databases working together is a spaghetti bowl of code linking to each other. We would connect 2600 customers out of their 4600 with addresses with one query, but then pull another 1800 with another query. So Nuethic built our own sandbox database to help with migration. We started migrating the data parts at a time to complete a new database on our sandbox server. Once that database was constructed, the final migration to BigCommerce happened. That final migration took about 4 hours.

Deployment: Deployment was a complete success. We set up a time for deployment with the new host, and the client.  We then had multiple training sessions with the client company to teach them how to use the new site. The new site was much faster, and contained more tools for the client. This new site has saved them a ton of time on payroll and increased their conversions overall since the launch. Check out the site at www.aiya-america.com