Dialog
Dialog Support   >   "How Do I...?" Series   >   Business & Industry
Dialog "How Do I...?" - Business & Industry

Find Importers and Exporters of X Product?

TOPIC: PIERS Imports (U.S. Ports) (File 573) and PIERS Exports (U.S. Ports) (File 571) are compilations of manifests of vessels loading and discharging international cargo at more than 130 seaports of the United States and Puerto Rico, and approximately 11 key seaports in PIERS Imports (Latin America) (File 574) or PIERS Exports (Latin America) (File 572). Details on each individual shipment are stored in the databases.

Principal applications include: identification of trade opportunities, monitoring imports and/or exports of products whose details are lost in traditional government reports, and identification of potential trade partners. All waterborne international trade movements are captured: containerized, break bulk, dry bulk, and tanker. There is approximately a two-month lag between vessel arrivals and the loading of the data into the files. The PIERS databases are produced by Commonwealth Business Media, publisher of The Journal of Commerce.

The following search shows how to identify product codes, and then find the companies that imported the products in PIERS Imports (U.S. Ports).

Note: There are two pre-formatted reports available in PIERS: one in PIERS Exports (U.S. or Latin America) (Files 571,572) and one in PIERS Imports (U.S. or Latin America) (Files 573,574). These reports aggregate the shipments of each company retrieved by a search statement and rank the companies by the weight of their total shipments. The company with the greatest total cargo weight appears first. Pre-formatted reports allow analysis of shipping patterns and trends that influence the marketplace.

 

COMMAND SUMMARY

BEGIN 573
SELECT CELLULAR(1N)(TELEPHONE? OR PHONE?)/PS,PN
TYPE S1/6/1-10
EXPAND PC=6846000
SELECT E3 AND S1
SELECT S2 AND PD=20070701:20070930
DISPLAY SETS
REPORT S3/IMPORTER
Enter a title for the report
Enter Y or a number to display importers


HOW TO...



1. BEGIN File 573 to search PIERS Imports (U.S. Ports)

2. SELECT terms. Restrict to the Product Shipped (/PS) and the Product Named (/PN) fields. By using a comma, you are “OR”ing the two fields. Use truncation (?) to retrieve all forms of the root word, e.g. telephone or telephones. Note that the terms “telephone?” or “phone?” are “nested” so that Dialog will search for those terms first. The proximity connector (1N) specifies that “cellular” appears near “telephone?” OR “phone?” within one word, in either order.


?B 573 
File 573:Piers Imports(US Ports) 2007/Dec W2
       (c) 2007 Commonwealth Bus. Media
      Set  Items  Description
      ---  -----  -----------
?S  CELLULAR(1N)(TELEPHONE? OR PHONE?)/PS,PN
            2554  CELLULAR/PS,PN
           33486  TELEPHONE?/PS,PN
           18414  PHONE?/PS,PN
      S1    1250  CELLULAR(1N)(TELEPHONE? OR PHONE?)/PS,PN



3. TYPE the first several records in Format 6.

This format shows the date of shipment, the Product Shipped, the Product Name and the Product Code. Use the latter to identify a Product Code (PC=) for your search.

To select the appropriate record number, look at the range of records in the TYPE command (e.g., 1/6/2).

Note: Some records have been omitted from this display.


?T S1/6/1-10 
  1/6/1 
  DIALOG(R)File 573: Piers Imports(US Ports)
  (c) 2007 Commonwealth Bus. Media. All rights reserved.
  
  0074906571 
  Product  Imported:     CELLULAR PHONE  ACCESS 

Product  Code:         6846000  (TELEPHONE; INSTRUMENT,EQPT,SUPPLIES)  

  Date  of Arrival (YY/MM/DD):   071117   
    
  1/6/2 
  DIALOG(R)File 573: Piers Imports(US Ports)
  (c) 2007 Commonwealth Bus. Media. All rights reserved.
  
  0074888873 
  Product  Imported:  CELLULAR  PHONE 

Product  Code:    6846000  (TELEPHONE; INSTRUMENT,EQPT,SUPPLIES)  
  Date  of Arrival (YY/MM/DD):   071118   
    
  1/6/3 
  DIALOG(R)File 573: Piers Imports(US Ports)
  (c) 2007 Commonwealth Bus. Media. All rights reserved.
  
  0074882312 
  Product  Imported:  CELLULAR PHONE  CASE 

Product  Code:      6846000  (TELEPHONE; INSTRUMENT,EQPT,SUPPLIES)  

  Date  of Arrival (YY/MM/DD):   071118



4. EXPAND the Product Code you have identified. Look for references pertaining to your product code number and related numbers in the index next to it.

5. SELECT the appropriate “E” Reference number(s); AND it with Set 1 (S1), your original search statement. This insures that you retrieve your desired product terms within this product code.

6. LIMIT your results to a specific date range. The colon indicates a range.

7. DISPLAY SETS (DS) to review your search strategy.


?E PC=6846000 

Ref   Items  Index-term
E1 10580 PC=6845000 (APPLIANCES; NOS) E2 10319 PC=6845050 (HAIR CURL & DRY DEVICE, FACE SAUNA) E3 31067 *PC=6846000 (TELEPHONE; INSTRUMENT, EQPT,SUPPLIES) E4 4354 PC=6846400 (COMMUNICATE EQPT,TELEGRAPH,TELETYPE) E5 79883 PC=6847000 (AMPLIFICATION EQUIPMENT) E6 44663 PC=6850000 (AUDIO EQPT; STEREO,RADIO,SCANNERS) E7 96425 PC=6852000 (TELEVISION APPARATUS, VIDEO RECORD) E8 1530 PC=6852045 (TUNERS; (ANY)) E9 3481 PC=6852050 (CONVERTERS; TELEVISION,RADIO) E10 19568 PC=6853200 (PHONOGRAPH, TURNTABLES, JUKEBOX) E11 1657 PC=6856000 (NAVIGATION EQPT;RADAR,SONAR,SOUNDER) E12 10439 PC=6857070 (ALARMS, DETECTORS; SOUND,SMOKE,FIRE) (...) Enter P or PAGE for more ?S E3 AND S1 31067 PC=6846000(TELEPHONE; INSTRUMENT,EQPT,SUPPLIES) 1250 S1 S2 1061 PC='6846000' AND S1 ?S S2 AND PD=20070701:20070930 1061 S2 2691027 PD=20070701 : PD=20070930 S3 111 S2 AND PD=20070701:20070930 ?DS Set Items Description S1 1250 CELLULAR(1N)(TELEPHONE? OR PHONE?)/PS,PN S2 1061 PC='6846000' AND S1 S3 111 S2 AND PD=20070701:20070930



8. Create a pre-formatted Importer Report with the REPORT command.

9. Enter an optional title for the report.

10. Enter Yes (Y) to accept all 48 importers, or specify how many companies’ shipment details you wish to see.

Note: charges for pre-formatted reports in the PIERS files are based on the number of shipments displayed. Each company could have several shipments. The minimum rate covers the first 100 shipments. Beyond that, there is a charge for each additional shipment.

So if, for example, the first company had more than 100 shipments, you would be charged accordingly. You can tell from your set results how many shipments are found in the search. For example, S3 had 111 results (or shipments) of the product.

You can also use the RANK command to check the number of shipments each company imported. The command in Files 573,574 is RANK IM. (In Files 571, 572 it is RANK CO). Enter HELP RATES 573 for pricing details for File 573.

Note: Part of this report is omitted from the display.


?.REPORT S3/IMPORTER
    Sorting    111 records

PIERS REPORT processing begins...
Processed  100 records

Enter title of up to 80 characters
?.IMPORTERS OF CELLULAR  TELEPHONES 

There are 48 importers (ranked by weight of shipments) in this report.
If you wish to view all of these importer listings, please press 'Y'.
If not, please enter the number of importers which you wish to view.
?y

               DIALOG(R)File 573 :Piers Imports(US Ports)
           (c) 2007 Commonwealth Bus. Media All rts. reserv.  

                        IMPORTERS OF CELLULAR TELEPHONES     

1. WIRELESS XCESSORIES GROUP, HUNTINGDN VLY, PA

                              Country  Arrival  Weight
Product Description           of Origin Date   (Pounds)    Quantity
=====================================================================
CELLULAR PHONE ACCESS         CHINA P 070715        547     48 CARTON
  ***Exporter: K MATE TELECOM ACCESSORIES, FANLING, HG KONG***
CELLULAR PHONE ACCESS         CHINA P 070715       2431    105 CARTON
  ***Exporter: HCT INTL, HSI CHIH, CHINA T***
CELLULAR PHONE ACCESS         CHINA P 070715       1884    157 CARTON
  ***Exporter: K MATE TELECOM ACCESSORIES, FANLING, HG KONG***
CELLULAR PHONE ACCESS         CHINA P 070806        309     20 CARTON
  ***Exporter: K MATE TELECOM ACCESSORIES, FANLING, HG KONG***
CELLULAR PHONE ACCESS         CHINA P 070904      13431    574 CARTON
  ***Exporter: TRENDY ELECTRONIC, NA, NA***
CELLULAR PHONE ACCESS         CHINA P 070917       4684    250 CARTON
  ***Exporter: K MATE TELECOM ACCESSORIES, FANLING, HG KONG***
CELLULAR PHONE ACCESS         CHINA P 070924       9211    658 CARTON
. . . .
CELLULAR PHONE ACCESS HG KONG 070917 4256 329 CARTON ***Exporter: SUPER CAPTAIN, TAIPEI, CHINA T*** --------- >>>Total shipped 125,341. pounds 2. GOBILE INC, BROOKLYN, NY Country Arrival Weight Product Description of Origin Date (Pounds) Quantity ===================================================================== CELLULAR PHONE CHINA P 070724 20123 1093 PIECES ***Exporter: GUANGZHOU LIAN GUANG ELECTRONIC, GUANGZHOU, CHINA P*** CELLULAR PHONE CHINA P 070913 17315 837 PIECES ***Exporter: GUANGZHOU LIAN GUANG ELECTRONIC, GUANGZHOU, CHINA P*** CELLULAR PHONE CHINA P 070930 20277 1071 PIECES ***Exporter: GUANGZHOU LIAN GUANG ELECTRONIC, GUANGZHOU, CHINA P*** --------- >>>Total shipped 57,715. pounds 3. TECHNOLOGY CONSERVATION, LECANTO, FL Country Arrival Weight Product Description of Origin Date (Pounds) Quantity ==================================================================== CELLULAR PHONES PTS BRAZIL 070908 41437 66 PACKS ***Exporter: SOLECTRON IND, CAMPINAS, BRAZIL*** --------- >>>Total shipped 41,437. pounds (....)

RELATED HOW DO I...? SOLUTIONS

 

NEED HELP?

Contact the Dialog Knowledge Center
Within North America +1 800 3 DIALOG (334 2564)
Outside North America 00 800 33 DIALOG (33 34 2564)
Web Form www.dialog.com/contacts/webform

Stock #: 54810; Last modified: 14 Sep 2011



You are viewing the
Dialog Classic Version

Click below to view the
DialogLink 5 Version
Dialog Home   |   About Dialog   |   Site Search
Copyright Notices   |   Terms of Use   |   Privacy Statement