CASE STUDIES

WEBSITE RESPONSE IMPROVEMENTS

Your website represents your company and should look its best, work correctly, and be fast. A beautiful website is useful to keep and retain visitors, but if your website is slow, they may lose interest and move on. Especially on mobile devices where performance plays a big role in the experience a user has with …

Your website represents your company and should look its best, work correctly, and be fast. A beautiful website is useful to keep and retain visitors, but if your website is slow, they may lose interest and move on. Especially on mobile devices where performance plays a big role in the experience a user has with your website.

There are many things that can be done technically to improve your website’s performance. The only way to tell though what needs to be done is to test the website with various tools. We will run these tests against your website and let you know how well it performs. We will then propose a number of changes that we can make to improve your website’s performance. These tests will be rerun to ensure the changes are working and show how well your site performs.

DATABASE PEFORMANCE IMPROVEMENTS

Your website represents your company and should look its best, work correctly, and be fast. A beautiful website is useful to keep and retain visitors, but if your website is slow, they may lose interest and move on. Especially on mobile devices where performance plays a big role in the experience a user has with …

A database is the foundation of most software. If it is performing badly, it can affect many areas of your application such as the website, batch processes, report generation, and so forth. This poor performance can have negative effects on employee productivity, custom experience, and cost you a lot of money.

We have 12+ years of experience working with relational databases such as MySQL, SQL Server, IBM DB2, MariaDB, Oracle, and PostgreSQL. At their heart a database is a collection of tables with the rows representing records and each column holding some type of data. Essentially a spreadsheet, but far more complicated and much more powerful. Having it work efficiently is one of the keys to proper database performance.

We will review your schema which is the structure of your database. How the tables are made, columns are defined, indexes into the table and their primary keys. After a thorough review, changes will be proposed and can be made if you wish. We will then setup query logging and look for poor performing queries and determine why they are taking too long to complete. Again, more changes will be proposed and can be implemented by us or your staff.

In addition to these types of changes, we are able to look at how your programs and programmers are using the database. Many times some simple changes in the programming code such as PHP, Java, or C# can have a big improvement on the performance of the database server. We look forward to helping you resolve your performance problems.

AMAZON DATA INTEGRATION

Our specialty is in working with all things Amazon. Whether it is their web services (AWS), their marketplace services for sellers (MWS), or their product advertising (PAAPI), we have many years of experience in creating software that works and performs well with Amazon. We can integrate your software and systems more closely with Amazon’s and …

Our specialty is in working with all things Amazon. Whether it is their web services (AWS), their marketplace services for sellers (MWS), or their product advertising (PAAPI), we have many years of experience in creating software that works and performs well with Amazon. We can integrate your software and systems more closely with Amazon’s and help automate the tasks so that you save time, money, and avoid errors that result when doing a task manually.

The programs we write can be run on your servers, on Amazon’s EC2, or on our own servers if you would like us to maintain everything. Our goal is to help your business and not pile a lot of technology and jargon on you. You want your business to run better, and that is going to be our focus. We will make recommendations based on your requirements that could help you get a lot more than expected. We have worked with many sellers that were looking for a small improvement and realized that they could get so much more. We will help you get the best solution for your company. And with our knowledge of how Amazon works, you won’t have to explain everything to us like you would a traditional developer.

PROCESS AUTOMATION

Custom software can enhance your business in many ways. By eliminating errors, improving throughput, and eliminating repetitive work, you can save money and increase income. As software development experts, we can create a solution for your business that will give you these benefits at a reasonable cost. Our experience with Amazon’s marketplace systems as well …

Custom software can enhance your business in many ways. By eliminating errors, improving throughput, and eliminating repetitive work, you can save money and increase income. As software development experts, we can create a solution for your business that will give you these benefits at a reasonable cost. Our experience with Amazon’s marketplace systems as well as their cloud computing platform allows us to create solutions that scale, integrate beautifully with Amazon and other marketplaces, and give you benefits that you can see right away. We have worked with small family based companies on up to those doing over $1B per year. We can handle the project ourselves or work with your staff as a subject expert and help make your project a success.

PO DATA RETRIEVAL

A client had data in BrightPearl where they created their purchase orders and had employees handle their suppliers. They needed a way to check in the products when they arrived at their dock, mark what was damaged or missing, and generate labels for sending the received products to Amazon using the FBA service. We created …

A client had data in BrightPearl where they created their purchase orders and had employees handle their suppliers. They needed a way to check in the products when they arrived at their dock, mark what was damaged or missing, and generate labels for sending the received products to Amazon using the FBA service. We created a custom tool that used the BrightPearl API to gather PO information and a webpage where these PO’s could be easily searched and the problem products marked and labels printed. This saved the company a great deal of time in their warehouse and helped avoid errors that were occurring when trying to copy the data manually. They were able to modify their warehouse processed to streamline it some in the process which meant handling the products fewer times.

SHIPMENT DESTINATION ORGANIZATION

A client wanted to separate products in their warehouse based on the location where the product was to be shipped. Amazon requires splitting shipments to different fulfillment centers, and their warehouse was set up that each production line would collect and process a shipment to a single fulfillment center. Amazon had made changes to the …

A client wanted to separate products in their warehouse based on the location where the product was to be shipped. Amazon requires splitting shipments to different fulfillment centers, and their warehouse was set up that each production line would collect and process a shipment to a single fulfillment center. Amazon had made changes to the FBA process, so the client needed a way to determine where a product was going to go when they received it.

We created a special tool that would check with Amazon where the product might go. The destination would be printed on the FNSKU label and this allowed them to route the products to where they were likely going to go. Although this wasn’t 100% accurate, most of the time it was correct and allowed them to keep their current processes in place and speed up processing in their warehouse. They had 50 people already trained and working with their current process well, and so changing it and retraining these people would have been a much more costly proposition.

VELOCITY REPORT

Knowing how much product to send to Amazon is something every seller needs to know. If you don’t send enough, then you run out of stock. If you send too many, then you pay storage fees. The client was using some reports that Amazon has for this purpose, but they wanted to take into account …

Knowing how much product to send to Amazon is something every seller needs to know. If you don’t send enough, then you run out of stock. If you send too many, then you pay storage fees. The client was using some reports that Amazon has for this purpose, but they wanted to take into account many more variables than the standard on-hand inventory, in-transit, sellable, and sales over the last 30 days. They wanted to take into account lead-time from the supplier, ordered inventory that was on its way from the supplier, time it took Amazon to check in their products when using UPS or LTL, and other variables that Amazon doesn’t account for.

A velocity report tool was created for my website SellersToolbox which the client now has perpetual access. It allows for variations between suppliers of any length, variations in Amazon check-in times, sales history from 1 week to 1 year, purchase timeframe from 1 week to 1 year, and supplier filtering. It shows profitability and margin values based on cost, the number of days before the product will run out, the number of units and dollar amount that is an overage for slow-moving products, and more. They can now deal with foreign suppliers where it takes 2-3 months for products to arrive, as well as from a supplier that can deliver within 2-3 days. All of the data is downloadable to a spreadsheet for easier handling.

CASE-PACKED SUPPORT FOR FBA SHIPMENTS

A client using an FBA tool to create shipments wanted it to support case-packed items. We worked with both the client and the owner of the software to enhance the tool so it could support case-packed items when a shipment was created that way. This saved the client from having to find another tool to …

A client using an FBA tool to create shipments wanted it to support case-packed items. We worked with both the client and the owner of the software to enhance the tool so it could support case-packed items when a shipment was created that way. This saved the client from having to find another tool to work with, possibly requiring them to change their business processes. The work also benefited the existing tool by making it more useful to other sellers.

SALES TAX DATA COLLECTION

A large company that handles sales tax data reporting had tried unsuccessfully to create a system that would pull in all of a seller’s Amazon sales tax data. We were contracted to create a system that would support 1000’s of sellers ensuring that the data was accurate, collected in a timely manner, and worked within …

A large company that handles sales tax data reporting had tried unsuccessfully to create a system that would pull in all of a seller’s Amazon sales tax data. We were contracted to create a system that would support 1000’s of sellers ensuring that the data was accurate, collected in a timely manner, and worked within Amazon’s guidelines and avoided throttling and other issues normally associated with using Amazon’s web services. The project has allowed the client to offer an Amazon collector to their clients and we are currently working with them on the collection of sales tax data with other marketplaces. We continue to work with this client by maintaining the software since Amazon frequently makes changes which must be dealt with to ensure the proper collecting of the sales tax information.

THE RIGHT TOOL

You need software that fits your business There are many, many tools out there for Amazon sellers. Amazon lists 13 categories of them in their app store in Seller Central. There are 52 for working with product listings alone. While all these tools want to help your business save time and make more money, they …

You need software that fits your business

There are many, many tools out there for Amazon sellers. Amazon lists 13 categories of them in their app store in Seller Central. There are 52 for working with product listings alone. While all these tools want to help your business save time and make more money, they all require you to work their way. You must alter your business processes and practices to fit how the tool works. This can be a difficult and expensive proposition if you are already using software to run your business. Sometimes all you need is to automate a certain process or bring data from Amazon into your tools so that you can work smarter and faster.

We can create just the software you need so you don’t have to modify how your business works. We will create the bridges you need so that data can flow between your business and Amazon. This is a much cheaper proposition and much less disruptive to your business. You will get the benefits without having to go through the pain of changing how you work. While having custom software built for your business might sound expensive, it can actually be far cheaper in the long run. We already have experience with Amazon and have built the basics that are needed for report processing, updating inventory and listing data, creating shipments, and much more. We won’t be starting from scratch which means much fewer billable hours for you.