top of page

Mini Dragon Group (ages 6-7)

Public·72 members
Thomas White
Thomas White


If you want to transfer a large amount of product information between Shopify and another system, then you can use a specially-formatted spreadsheet to import or export that data. Shopify uses CSV (comma-separated value) files to perform this kind of bulk task.


When goods move from any foreign country to the United States, they are being IMPORTED. There are specific rules and regulations that govern the act of importing - and they can be extremely complex and confusing - and costly.

That artisan cheese from Italy may be a snap to find and buy on the Internet, but U.S. Customs and Border Protection could seize your purchase because certain regulations prohibit the importation of dairy products from particular countries without a permit.

In other words, "Buyer, Beware." When you buy goods from foreign sources, you become the importer. And it is the importer - in this case, YOU - who is responsible for assuring that the goods comply with a variety of both state and federal government import regulations. Importing goods that are unsafe, that fail to meet health code requirements, or that violate quota restrictions could end up costing you quite a bit of money in fines and penalties. At the very least, such goods would be detained, and possibly destroyed, by CBP.

It does not matter whether you bought the item from an established business or from an individual selling item in an on-line auction. If merchandise, used or new, is imported into the United States, it must clear CBP and may be subject to the payment of duty as well as to whatever rules and regulations govern the importation of that particular product into the United States.

Note: It is important to know that foreign shipments that are not accompanied by a U.S. Customs and Border Protection declaration form and an invoice may be subject to seizure, forfeiture or return to sender.

U.S. Customs and Border Protection does not inform importers of the arrival of cargo or freight. When cargo or freight arrives at a U.S. port of entry, it is the responsibility of the shipper or a designated agent to inform the importer of its arrival. However, proper notification does not always happen, particularly, if the shipper has incomplete contact information for you, the importer. Therefore, it is important to find out the scheduled arrival date of your import and follow-up.

Importing Process Paying Duty: The importer is ultimately responsible for paying any duty owed on an import. Determining duty can be very complicated, and while shipping services will often give an estimate for what the duty rate on an item might be, only CBP can make a final determination about what is owed. You should not be misled into thinking your purchase price includes duty because the seller cannot say with absolute certainty what the duty will be. As a rule, a purchase price that includes shipping and handling does not include duty or any costs associated with clearing the goods through CBP. First time importers are often surprised by bills they receive for duty, U.S. Customs and Border Protection merchandise processing fee, and something referred to as "customs fees," which are actually charges for the services of the broker who cleared your goods through CBP.

For Commercial Purposes: Goods imported for commercial purposes must comply with a variety of special requirements, such as marking of country of origin, which vary depending upon the particular commodity. Please see our publication, "Importing Into the United States," for more detailed information. Be particularly aware that an invoice should always accompany commercial shipments.

Because filing a formal entry can be complicated, the U.S. Customs and Border Protection recommends importers consider hiring a customs broker to complete the transaction. Lists of brokers can be found on the port pages of CBP web site.

One of the most difficult things about filing formal entries is accurately identifying the correct classification number of the item being imported. The Harmonized Tariff Schedule of the United States (HTSUS) lists classification numbers for every conceivable item under the Sun. The HTSUS is the size of an unabridged dictionary, and specialists train for months to learn how to correctly classify goods.

The classification number of an item determines many requirements pertaining to that item's importation such as its duty rate, eligibility for special import programs like the Generalized System of Preferences (GSP) or the North American Free Trade Agreement (NAFTA), and whether or not the item is subject to quota restrictions.

Failure to correctly classify an item can result in fines and/or delays in delivery. You may write to U.S. Customs and Border Protection for a binding ruling, and/or contact an import specialist at your local port for help to identify the proper classification number for your imported item.

In some cases, the quota is absolute, meaning that once the quota is filled - because the quota has reached its limit for that particular period of time - no additional quantities of that item may be imported until the next open period. Such merchandise must be warehoused or exported. Other quotas are tariff-related, which means that a certain quantity of goods may enter at a low rate of duty, but once that threshold is reached - during a specified period of time - a higher duty rate will be assessed for any additional quantities of that particular imported good. Unlimited quantities of some merchandise subject to tariff-rate quota may, however, enter at over the quota rates.

The Quota program is generally applied only to commercial importations. While the importation of many goods imported under "personal use" quantities are not affected by quota restrictions, there is one exception; made-to-measure suits made in Hong Kong, which are restricted for both personal and commercial use.

If you are sending goods to someone outside the United States, you should be aware that most countries have similar regulations governing the importation of goods into their territory. If you are selling goods on a "Payment on Delivery" basis, you might want to contact the Customs authority of the country where the goods are being shipped to make sure they can legally be imported into that country. In addition, some commodities sold for export are subject to enforcement requirements of U.S. Customs and Border Protection and other U.S. government agencies. In particular, cars and goods with potential military applications, including some electronics and software, must be cleared through CBP before they are exported. And if you export goods worth more than $2,500, you will have to follow formal export procedures.

If you are a Shopify Partner and you are performing a large scale import for a merchant, then make sure that you test a small subset of changes first using a development store before you perform the actual import job.

When you import a CSV file, you can select the option Overwrite any current products that have the same handle. Existing values will be used for any missing columns. If you select this option, then when the handle in the import CSV file matches an existing handle in your products list, the values in CSV file overwrite the values in the matching columns in the existing product list. If the overwrite option isn't selected, then the products that match an existing handle will be ignored during CSV import.

For example, the Vendor value in your existing product list is John's Apparel, but the Vendor column is blank in the CSV file that you import, then the John's Apparel is overwritten as blank.

For example, if the Variant Image column is included in the existing product list, but that column is not included in the import CSV file, then the value in the product list remains the same.

If you have a CSV file that was exported from another store or came from another source, verify that it matches the CSV file format. If the format doesn't match, or if there are any missing headers, then the import fails.

If you want to make changes to your products using a CSV file, then you need to export your products first. You can make changes to your CSV file in a spreadsheet program like Google Sheets, then import your updated CSV into the Shopify admin.

As part of the Customer Connection Program, this function will enable to export the Shopping Cart as an Excel file. You can edit the Shopping Cart data offline, and import the changed file to the Shopping Cart screen. For Shopping Carts that contain more data, depending on your system settings, export and import can be executed as a background process.

Create a Shopping Cart with or without items and click on "Export". Shopping Cart item data such as item details, longtexts, partners, tax data, account assignment, etc. will be exported in a MS Excel file. Header and item details are available as separate tabs in the Excel file. You can drill down to the item substructures with the help of the "+" buttons.

The functionality takes the Shopping Cart GUID as reference value, so exporting from a Shopping Cart and importing the Excel data to another SC-instance is currently not possible. You can leverage the functionality within the same Shopping Cart instance.

Items that use rich text formatting will have HTML tags included in the item descriptions in export files. Items without rich text formatting will not have HTML tags included in the item descriptions in export files. HTML tags are small pieces of code such as "" and "".

While you are able to import the CSV data into a spreadsheet, if your item library contains SKUs do not open the CSV file directly as some spreadsheet editors will modify your SKUs in unexpected ways. Specifically, they may remove leading 0s (ex. 0012345 will become 12345) or convert them to scientific notation (ex. 12345678999 will become 1.2346E+10).

Note: If you need to revert to a recent version of your Item Library, you can undo an item import from the Items page of your online Square Dashboard > Actions > Undo Catalog. 041b061a72


Welcome to the group! You can connect with other members, ge...
bottom of page