Welcome to Import Export Book

The little book of big import export ideas and tips that prepares adventurous entrepreneurs to travel for fun and profit.

Need Help?

Importers-Exporters

panjiva_inc_logo

[toc]
In our series of online competitive tool reviews, ImportExportBook.com takes a closer look at, Panjiva, founded in 2006 by Josh Green and Jim Psota. Initially launched as GlobalReferenceCheck, co-founders Green and Psota played on Pangaea, the word for the supercontinent that existed before the component continents were separated into their current configuration, to arrive at the brand name – ‘Panjiva’.

Trade Alert:

The first 5 people to reference this ‘Spotlight Review: Panjiva.com’ article will get 1-week free full trial of Panjiva’s ecommerce engine. This offer only applies to new Panjiva users only.

Introduction & Background

Panjiva.com was born to change the way companies trade across border with objective source of background information. It was launched as a tool deemed to be ‘the most comprehensive source of information on over one million companies from 190 countries’. In this chapter, we will focus on how importers and exporters (who are international buyers) can make use of Panjiva’s data to answer these buyer’s questions:

  1. Which oversea suppliers, factories, manufacturers, wholesalers are safe for my company to associate with? What is the long-term health of these offshore companies? Who can I really do business with?
  2. Where are my competitors sourcing from?
  3. Which suppliers that approach me for business is safe for me to deal with?
  4. Am I dealing with a parent company or subsidiary firm?
  5. Who is the biggest US importer for a particular product?
  6. How a specific buyer-supplier relationship evolves over time? (provided these companies did not opt-out from data collection like what Apple did for their upcoming iPad product launch)
  7. How can I avoid getting burnt from a contract manufacturing partner in developed or developing nations?
  8. How can my team share notes among sourcing colleagues to determine the risk/profitability of a buyer/supplier’s relationship? In my opinion, another golden question that needs to be answered for real time collaboration!

Pricing

Panjiva doesn’t offer a try-before-you-buy model for tire-kickers.

The monthly subscription starts from $399/per month for individuals, $999/per month for a team, $2499 per month for professionals. Don’t forget that this is just the cost of screening suppliers, as you have to budget for quality control, on time delivery, product adaptation and so forth.

Panjiva Pricing Plan

Panjiva Pricing Plan

User Experience

Do Panjiva offers a competitive advantage in their international market research? Unlike ImportGenius offering more general shipping data, it’s potential user base can be classified in such a way:

  • Sourcing executives of major corporates, trade organizations and large buying organizations who want to screen, monitor and vet factory partners, competitors and suppliers with rigorous assessments
  • Major investors, economists, stock brokers and business analysts who wants to access accurate and independent information of the global supply chain with aggregated public and proprietary sources
  • Manufacturers who want to deal with reliable sourcing companies (potential partners) importing products or components similar to the ones they sell
  • US and non-US importers and exporters can use it to:
    • track ‘hot’ and ‘not-so-hot’ upcoming product launches and consumer sales
    • analyse the ‘highs’ and ‘lows’ of import-export shipping trend with the creative use of various ‘search’ parameters
    • track what suppliers are closing down or expanding trade activities in order to invest more time, money and effort to invest in the right factories and manufacturers
    • identify socially responsible suppliers who demonstrate compliance towards human rights and labour standards stipulated by Social Accountability International (SAI)

Nevertheless, you can still identify broad segments of manufacturers by country and by region (with the shipping port data) with their free data. For example, I want to shortlist wine producers for my supplier list. I can take the following steps:

Step 1: Identify active suppliers in popular regions

As a new wine buyer, I can identify Australia and Argentina as my business destination to source for the right suppliers. I’ll start with 2084 suppliers.

Sort Wine Suppliers by Country

Sort Wine Suppliers by Country

Step 2: Shortlist suppliers with Panjiva Rating

Since I’m having my holidays in Adelaide, Australia, and I prefer to deal with these new suppliers face-to-face, I will filter the most active manufacturers in Q1 2010. Out of 453 Adelaide wine suppliers, there is 42 active suppliers for Q1 2010 quarter.

Filter Wine Suppliers by Foreign Port

Filter Wine Suppliers by Foreign Port

Filter Wine Suppliers by Shipment

Filter Wine Suppliers by Shipment

Step 3: Shortlist suppliers with 90+ Panjiva Ratings

I will then evaluate, select and qualify the remaining top 8 ‘healthy’ suppliers with the strongest potential to trade across border. I use the term ‘healthy’ because I can’t determine whether this data will lead me to trade with companies that live up to the Panjiva Ratings standard.

Identify Wine Suppliers with Top Panjiva Ratings

Identify Wine Suppliers with Top Panjiva Ratings

Step 4: Verify single supplier’s customer list

As I analyze those data, I noticed that there is actually 5 suppliers from Adelaide with the other 4 from other region. If I did not pay for a Panjiva subscription, I can only guestimate that the other 4 interstate suppliers make use of Adelaide port to export Australia wines overseas. However, if I pay for the subscription, I can magically pull up a list of customers, and true enough, these suppliers have records like a recent shipment from Adelaide to Oakland, California! (see below screenshot)

Australia Wine Supplier's Customer List

Australia Wine Supplier's Customer List

Step 5: Screen individual supplier’s shipping trend, credit report, certification and buyer-supplier relationship etc

As an international buyer, I can tap on the aforementioned paid features to get a deeper understanding of business viability with the shortlisted suppliers. We will cover the depth at a later stage. Want more interesting data points to help you with your analysis? Please read on further.

Core Functionality

a) Trade Database

As no single data point is perfect, Panjiva has applied reasonable effort to compile its import database along with its affiliate data feeds to provide a holistic view of a single supplier’s reputation. Since Panjiva’s core customers are mainly from apparel industry, these data sets have yet to offer complete data points that fulfill IMEX Standards. So, Panjiva only offer a facility to ask for more certificate verification for other niche industries.

Panjiva's Certificate Verification Facility

Panjiva's Certificate Verification Facility

Its database integrity is probably situation-specific as each country’s risk level is different. For example, Jason from SpendMatter explained how Chinese government data may not be as accurate as one wish. He nicely summed up that:

a onetime profiling effort should never be a substitute for consistent and proactive monitoring overtime — nor, when it comes to China especially, should it substitute for continuously monitoring supplier performance management trends as well.

b) Macroeconomic Intelligence – Panjiva Trend

Panjiva Trend helps to aggregate US import trend and profile hot vs not-so-hot demand for the searched product in their world’s heatmap. Panjiva Trends will soon become a part of the company’s Executive Dashboard offering, which will be made fully available in early 2010.

Panjiva Trends

Panjiva Trends

c) Competitive Intelligence – Shipment Stats per Supplier

As a paid user, you can dice the shipment data by size, volume per month/year, departure and arrival port, which gives you a bird’s eye view on how diverse or how consistent is a particular supplier’s import-export activities. By knowing a supplier’s past shipping activities, you can estimate the level of loyalty given by a supplier to your very own market.

Panjiva's Wine Supplier Shipment Stats

Panjiva's Wine Supplier Shipment Stats

d) Market Research – Panjiva Rating

The Panjiva Rating feature is an aggregated data score to help you judge the strengths and weaknesses of each suppliers. It is a rating from 1 to 100. Here’s the rating breakdown:

  • A rating of 90 or higher means a supplier’s volumes to the U.S. are growing year over year
  • A rating between 70 and 89 means a supplier’s volumes to the U.S. are stable
  • A rating below 70 means a supplier’s volumes to the U.S. are declining
  • A “Not Rated” means we have insufficient data on that supplier to give it a meaningful evaluation. This could be because a supplier hasn’t shipped a lot to the U.S., or because most of the supplier’s customers have opted out.

This rating takes into account factors such as a supplier’s international track record and compliance efforts, whether it is registered as a legitimate business, the types of products it has shipped and to what types of customers, and how loyal its customers have been. Through the ratings, companies can reduce the time and cost of finding high-quality suppliers, and they are able to draw conclusions about which suppliers are good or bad. In a competitive business environment, you have to constantly build relationships. And, Panjiva Rating can inform you which relationships are worth investing to in the long term.

Track the Good, the Bad, the 'Unknown' Suppliers with Panjiva Ratings

Track the Good, the Bad, the 'Unknown' Suppliers with Panjiva Ratings

Panjiva’s chart can possibly show a massive decrease to nearly zero kilograms. This can happen when a particular supplier:

  • changed its location
  • has gone defunct
  • opt out from the US Custom’s public shipping data (see below screenshot)
Example of Nike Opting Out of US Custom Data and Panjiva

Example of Nike Opting Out of US Custom Data and Panjiva

e) Re-usable Search Data

When you are done with your shortlisting process, you can:

  • save it as ‘future alerts’
  • bookmark it in your MyPanjiva dashboard
  • export your search results  as CSV/Excel file
  • email your data to a trade analyst or yourself for future reference.
  • make quick notes about a particular supplier (see below screenshot)
Panjiva allows your Sourcing Team to Share Notes

Panjiva allows your Sourcing Team to Share Notes

Value-added Features

a) Analyze and Discuss In-depth Shipping Data

One of the beauty of Panjiva is that users can search, sort and filter suppliers’ shipment data. You can search with general keywords like ‘wine‘ and long tail keywords like ‘Australia red wine‘. General keywords offer more filtering options like ‘certification’ and ‘affiliate data’ for free users whereas long tail keywords enable users to focus their search intent on specific filtering options like ‘Panjiva Ratings’, Australian suppliers with red flags, Australia-only ports etc. There are tons of creative ways to refine your search with shipment date parameters, HS Code, SAI Certified, WRAP Certified etc, which we will discuss in our virtual chamber of commerce member’s chapter.

Once those data is collated, you can identify whether you have similarly targeted buyers on the supplier list. For instance, I am interested to export wine from Australia to France. As I verify the supplier’s customer list, I found out that one of the buyer, who is from France, also has 11.4% of supplies from my shortlisted suppliers (see below screenshot). In other words, I can confirm that the supplier may be keen to develop its business opportunities further in France.

Panjiva's Supplier-Buyer Relationship Profile

Panjiva Allows User to Evaluate Supplier-Buyer Relationships

b) Uncover Disguised or ‘Secret’ Brand Names

As some firms will not ship under their own brand name, but under another parent company, you can rely on Panjiva’s advanced search feature to track changes in owner’s brand name by spotting changes in ‘consignee names’ and ‘addresses’ in between a time period or  identifying a similar buyer’s pattern among different ‘consignee names’ and ‘addresses’.

Panjiva can track uncover secret brand names

Panjiva can track uncover secret brand names

c) Spot Unusual Supply Chain Activities with Panjiva Alerts

Want to avoid getting burnt by unreliable suppliers? Want to find out whether it is time to substitute your badly-performed suppliers? You can sign-up for Panjiva Alerts to get more insightful supply chain information.

API Access

Panjiva has charted on its roadmap to give affiliates an opportunity to make use of their data in their own creative ways. The OnPanjiva program is now open for integration with a broader set of information provider who shares the value of building the ultimate global ecommerce search engine.

Summary

These are the 3 questions that stands out after I assess this tool:

Can Panjiva help importers and exporters to make sense of messy datas?

If selection and assessment of qualified vendors or suppliers prove to be challenging to you, then Panjiva can be better than other web-based business directory and credit rating sites as it aggregates research data with amazing filtering precisions. Especially for importers and exporters, they can increase their bargaining power to ask for a better price from their existing suppliers and work with suppliers who have consistent or strong shipping track record.

Does incomplete data means that its better to have some data than no data?

Panjiva’s data is incomplete in 2 ways:

  1. It only tracks vessel shipments to USA
  2. Every buyers has the ability to opt-out of the US Custom data

Unlike Google search engine, its focus on trade search results is less likely spammed with junk company listing. However, due to its lack of maturity, I still think that having some of its data can surely assist US importers and exporters in the selection and assessment of vendors in markets that trade with USA. For non-US importers and exporters, it would be better to cross check your supplier short list with a free account with the particular company’s website. If there is a lack of company information online for most of the companies you intend to deal with, then it is safe to bet on Panjiva’s data to reduce your buying risk. For big orders, buyers should not leave any risk on the table. You can perhaps post a request in our import export forums or import export job board to engage a ‘friendly spy or agent’ to meet up with the foreign supplier in order to complement their supplier search effort with Panjiva’s incomplete database.

Does it provide a competitive edge to international buyers?

Trade details are obviously available and reported in many trade websites. But, combining trade data and trade analysis is surely an ‘edge’ for buyers who fill the ‘knowledge gap’ of competing in fast changing industries like apparel retail or consumer electronics. In terms of return on investment, it will be much cheaper to use Panjiva’s data than to hire a competent analyst who will probably end up using a tool like Panjiva to do the job. Moreover, Panjiva’s fundamental analysis (Panjiva ratings) and technical analysis (detailed shipment stats) of suppliers can be cheaper than a business trip in a 5 star hotel yet allowing you to make a decision to deal or not to deal with a supplier from home.

As VentureBeat wrote:

The White House doesn’t yet have much to show yet for its efforts to make the government more transparent. But, unsurprisingly, the private sector is forging ahead where there are business opportunities.

Panjiva’s effort to become the next search engine for global ecommerce is highly commended. And, I’ll highly recommend this tool to international buyers who have the patience, time and analytical skills to play the game of international trade.

Trade Alert:
The first 5 people to reference this ‘Spotlight Review: Panjiva.com’ article will get 1-week free full trial of Panjiva’s ecommerce engine. This offer only applies to new Panjiva users only.

Related Posts:

{ 3 comments }

import-genius
[toc]
In our series of online competitive tool reviews, ImportExportBook.com takes a closer look at an Arizona startup, ImportGenius, founded in 2008 by brothers Ryan Petersen (One of the Principal of Faculty Imports), David Petersen and Michael Kanko. It was launched as a tool that is deemed to be far more comprehensive than the US custom database with more relevant data points.

Introduction & Background

ImportGenius.com offers a competitive intelligence tool for small businesses to search international trade records. As importers and exporters, you can use their data to answer these questions:

  1. What and where your competitors import their products from and export their products to?
  2. Which oversea suppliers, factories, manufacturers, wholesalers import to USA?
  3. Which suppliers, factories, manufacturers, wholesalers are infringing your intellectual property rights?
  4. What is the overall demand for a given product?
  5. What are publicly traded companies ordering from overseas? When are they having major product launches?

However, the company is prudent enough to give me a tongue-in-cheek response when I ask ‘What about dangerous goods like rifles?’. This is Ryan’s verbatim reply:

‘Until September 11, 2001, it was actually possible to access data on the imports entering the country before they arrived. However, as a security measure customs no longer allows access to the records until after the goods have cleared and been removed from the port. This makes it much harder for somebody to attempt to intercept shipments. Anyway, if you want a rifle just go down to K-Mart and I think you can get one for like $200.’

Of course, this tool is launched with certain level of controversy, which can possibly lead to lawsuits. For example, Michael S.Cooke, a US custom broker, aptly pointed out that:

I find it strange that Import Genius is allowed to sell confidential information on the Internet without the importer of records consent. Customs Brokers are required to keep strict confidentiality of importer records which may only be shared with 1) CBP 2) The Customs Broker 3) The Importer. Yet Import Genius sells this information in the public domain? Importers will go to great lengths making sure this information (the information Import Genius provides) does not reach the buyer or ultimate consignee. And rightfully so because they have a right to privacy; not to mention the buyer will ‘cut them out’ and go direct to the supplier. I wonder how many importers and middleman distributors have been put out of business by Import Genius?

User Experience

ImportGenius targets this list of users. Being a non-US user, I believe that these users are the main winners (if they know how to analyze the data – which I’ll explain further in the importance of having a ‘911 mindset’):

  • Major importers and exporters can pre-empt competitor’s shipping cycle, and enforce copyright protection, and of course, this will lead to more:
  • Major investors, economists, stock brokers and business analysts can perform trading estimates with their ‘crystal ball’ as they establish a trend between revenues and imports among publicly traded companies. This can help them to estimate a company’s earnings long before its quarterly press release (which could turn the stock market on its head)
  • US manufacturers can reduce cost when they:
    • Research and monitor overseas suppliers for companies selling knock-off versions of their products with lawsuit wins
    • Identify sourcing companies (potential partners) who are importing products or components similar to the ones they sell
  • US importers can use it to find suppliers, monitor competitors, and enforce exclusivity contracts
  • US and non-US importers and exporters can use it to:
    • track new product launches and investment
    • analyse the ‘highs’ and ‘lows’ of import-export shipping trend with the creative use of various ‘search’ parameters
    • engage in more ‘exciting’ conversations and negotiations with existing suppliers on such data to remove the barrier of trade

Pricing

There is no free trial, so the monthly subscription $99/per month price tag can be slightly steep for budding importers or exporters. I have not thoroughly test the system but some users found that there are too many duplicates data. So, it’s hard to come to a conclusion on whether the cheaper price, in comparison to other paid tools like Datamyne or Zepol, justifies your margin to buy the limited data that is only available since January 2006.

account-type

Figure 1. ImportGenius Pricing Plan

Core Functionality

Database

ImportGenius boasts that the company’s database contains every shipment data entering the United States (AFTER the product enter US), allowing businesses to access contact information for each of their competitor’s overseas suppliers, or each of their overseas supplier’s U.S. customers. The Freedom of Information Act gives the company the right to organize, and republish the publicly available US Custom and Border Protection database available on a ‘nice interface’ (rarely found in government system). In essence, their database dump is fed by an Automated Broker Interface (ABI) made available for free by CBP.gov! So, it’s simply an act of ingenious marketing when ImportGenius put those data to effective use when they hype about the Apple iPhone prelaunch story resonated in repetitive media circles!

To protect its data integrity, ImportGenius have made it clear that they will not accept payment for removing company’s information from their database.

Competitive Intelligence – ImportScan

ImportGenius has a flexible and powerful searchable index called ImportScan to identify key Bill of Lading information for your industry vertical like date range, consignee, products, shippers, Bill of Lading numbers, port information, weights and measures.

sort-by-bill-of-lading-info

Figure 2. Sort Your Data in ImportGenius by Consignee

sort-by-dateFigure 3. Sort Your Data in ImportGenius by Date Range

Market Research – SupplySpy

This feature allows you to further sort and filter your search for further product and transit details to get more in-depth information of your competitor’s trade mission.

competitor-info

Figure 4. Sort Your Data in ImportGenius by Product Details/Transit Details

Then, you can detect your supplier’s location with the Google Maps feature. For instance, you can spy on a shipper from China with all the transit details to find out how big is the order from China to your competitor’s warehouse or office in USA. How cool is that?

map-location

Figure 5. Spy your Competitor in ImportGenius GoogleMap

Exportable data files

When you are done, you can format your report as CSV, Excel file and share it with your import export team members.

Value-added Features

Visual Mapping

It’s a very powerful tool for quickly identifying related companies in the database. Sadly, the visual mapping doesn’t work for me.

www.importgenius.com visual mapping 2009-11-24-16-53-19

Figure 6. Visual Mapping Beta Feature in ImportGenius

Saved Searches

A nifty way to review my search results is to save all my previous searches before downloading the report but sadly, this feature doesn’t work for me either.

www.importgenius.com saved search 2009-11-24-16-52-42

Figure 7. Saved Search Feature in ImportGenius

API Access

ImportGenius is open to discussing API access on a case-by-case basis as sensitive data has to be handled carefully.

The Stress Test

ImportGenius website claims that:

By collecting the ocean freight bill of lading for all U.S. imports in our database, ImportGenius provides unprecedented access to near real-time information on virtually every industry and company importing goods into the country.

P/S: My testing account accidentally got suspended twice while trying out to verify this claim. So, I’m waiting for ImportGenius customer service team to get back to me.

Summary

ImportGenius database certainly have some interesting features but its reliability is questionable. Although it is easy to use, it is tricky for users to document and verify the flow of its data point. For example, company ABC in US which import goods from Australia, may have their goods docked in China for few days prior to being shipped to the US. This means that the data can only be justified with on the ground trade logistics experience. Besides, the manufacturer’s name may be fabricated with third party names (especially for consumer packaged goods), and it will not be reveal by most trading or export companies. The only question is whether it is worth to spend such effort and money to conceal their trade identity with shell companies or importing through third parties for the sake of ‘avoiding spies’.

I believe that ImportGenius can add more value by offering initial data analysis support service, so that new users can gain actionable insights for their own use. If not, it would be easy for users to get addicted to the minute details of each generated reports, which defeats the purpose of gaining a competitive edge in the global trade market.

However, if shipping volume can impact your import-export business bottom line and you have the analytical ability to understand Bill of Lading reports, then this tool is definitely worth a look.

Have you try it yourself? What are the creative ways that you can suggest in making good use of such tools?

If you have heard of any import genius lawsuit or import genius scam, please comment here.

Related Posts:

{ 4 comments }

3 Must-Have Small Business Calculators for Exporters

Due to popular demand, I recently published two different ‘Export Readiness Test’ surveys to help small business owners to decide whether exporting is a right alternative for them, especially in this time of economic uncertainty. Alongside these surveys, I have included 3 different types of calculators to help exporters to

Read the full article →

A Day in the Life of an Importing Agent

Before you ask yourself, ‘How to Become an Import Export Agent?‘, you may like to find out whether an ever changing lifestyle of an import-export agent fits your personality. Do take note that most importing agent also work on exporting leads. 07.00 – 08.00 Wake up to read RSS feeds

Read the full article →

Alibaba Trade Manager Software Review

Alibaba Trade Manager, works like QQ or MSN messenger. It offers instant communication between buyers and sellers. Alibaba Trade Manager Review Verdict: Pros: automatically start-up alibaba trade search and offer the latest manufacturing news (goes along nicely with a cup of coffee) you can directly contact supplier or buyer without

Read the full article →

5 Disadvantages of Importing You Must Know

As you turn on the TV today, a news reporter was interviewing a guy who can’t find any ‘plus size’ shirt in a retail store. Poor guy. He got rejected in almost every retail clothing store he went. He’s obese but he cannot find any shirts that fit him after

Read the full article →