{"id":19040,"date":"2020-05-13T16:10:38","date_gmt":"2020-05-13T23:10:38","guid":{"rendered":"https:\/\/www.crystalcommerce.com\/blog\/?p=19040"},"modified":"2020-05-13T16:10:40","modified_gmt":"2020-05-13T23:10:40","slug":"update-your-quantity-and-prices-for-your-cards-and-games-easily-with-mass-create","status":"publish","type":"post","link":"https:\/\/www.crystalcommerce.com\/blog\/2020\/05\/13\/update-your-quantity-and-prices-for-your-cards-and-games-easily-with-mass-create\/","title":{"rendered":"Update your quantity and prices for your cards and games easily with Mass Create!"},"content":{"rendered":"\n
\"This<\/figure>\n\n\n\n

There are mainly two ways to add inventory to our system.<\/p>\n\n\n\n

The first is to find the product and edit the price first then quantity after.<\/p>\n\n\n\n

Doing this one item at a time can get quite tedious, which is why another better way of doing this would be using our Mass Create!<\/p>\n\n\n\n

(Note, this article uses Admin 2.0 but the steps will work with Admin 1.0 which very small modifications)<\/em><\/p>\n\n\n\n

Updating Prices <\/strong>(always update prices first)<\/h1>\n\n\n\n

First, head over to your Inventory Tab<\/strong><\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Next, select the category that you would like to update<\/strong> (we will choose Theros Beyond Death)<\/em><\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Find the button with the three …<\/strong> and click it, then select ‘Export search results to CSV’<\/em><\/strong><\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

You will be taken to your File Reports<\/em><\/strong> page. (if you need to visit here again, you just need to click on Notifications > “You have xxx file reports”<\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Depending on the size of the csv, it may take a few seconds or a couple of minutes. Once ready, click to Download<\/strong> Report<\/strong><\/p>\n\n\n\n

When you view the spreadsheet file, it’ll look a little like this:<\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

As we are only updating Quantity and\/Or Prices, a lot of the columns here are not needed. Do not hesitate to remove them.<\/p>\n\n\n\n

*Please refer to the mass create tab for columns that can only be used for the mass create*<\/strong><\/p>\n\n\n\n

For our task, we are only updating the prices of cards.<\/p>\n\n\n\n

Remove all the columns apart from:

Product Name
Category
Sell Price<\/strong><\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

We can then put our spreadsheet on one side of our screens, and have another browser that can show us the price of cards on the other side, and update accordingly.<\/p>\n\n\n\n

You can use any method and any source you like to update your prices.<\/p>\n\n\n\n

Once you have your updated spreadsheet, head over to Inventory > Mass Create<\/strong><\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

For the next step, as we already have our spreadsheet with a category<\/strong>, we can check the option that says “This import contains multiple categories”<\/strong>. If you do not have a category in your spreadsheet, uncheck this and choose the category from the dropdown for Step 1<\/strong><\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Step 2: Double check the information here as it will tell you what can and cannot be uploaded<\/strong><\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Step 3: Choose your file to import.<\/strong>
Make sure you have checked Category and name<\/strong> (as those are the columns we have chosen to use in our spreadsheet.
Then, choose Only Update Products<\/strong>. This will only update your products (Reading the card, explains the card…<\/em>)<\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

And success! You’ve just uploaded your spreadsheet to update your prices!<\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Click on the Notifications on the top right hand corner to view the status of the mass create:<\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Our first line here shows us that 500 products were updated!<\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Here we can see that our card was updated to $1.08!<\/p>\n\n\n\n

Updating Quantity<\/strong><\/h1>\n\n\n\n

Updating Quantity is a similar process to updating prices, but there is an additional column\/s<\/strong> and there are two options to choose:<\/p>\n\n\n\n

When we update the quantity of a card \/ game, we need to tell the system, which condition are we adding quantity to?<\/strong><\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Using the card Dalakos, Crafter of Wonders<\/strong> as our example again, we see that it has 5 different conditions, Near Mint, Light Play, Monderate Play, Heavy Play and Damaged.<\/strong>
Note that there is even a Language variant, English<\/strong>.<\/p>\n\n\n\n

So for our spreadsheet, we need to make sure that we add 2 more columns to it:<\/p>\n\n\n\n

Condition
Language<\/strong><\/p>\n\n\n\n

So if we had cards for Dalakos, Craft of Wonders in Near Mint, Light Play, Moderate Play and Heavy Play, we would modify our spreadsheet like so:<\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Notice how each Dalakos card has a corresponding Condition and Language.
If you are not updating a certain condition and\/or language, there is no need to include it.<\/p>\n\n\n\n

Next, we need to add a column for updating Quantity.<\/p>\n\n\n\n

There are two columns you can use, Qty <\/strong>or Add Qty<\/strong><\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

Qty<\/strong> allows you to enter in a number, and the system will take that value and that will be the quantity for that card.<\/p>\n\n\n\n

If you were to use Add Qty <\/strong>instead as the column, that would take the value on the spreadsheet, and ADD <\/strong>it to the value you have in your system.<\/p>\n\n\n\n

Now when we process this spreadsheet (refer to the Mass Import section above), it will add quantity to our system for this card!<\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

For more information around mass update, check out our help articles here!

http:\/\/help.crystalcommerce.com\/en\/articles\/1296813-inventory-mass-create-tab-overview<\/a>

http:\/\/help.crystalcommerce.com\/en\/articles\/1389615-troubleshooting-common-mass-create-errors<\/a>

http:\/\/help.crystalcommerce.com\/en\/articles\/1390110-mass-create-create-update-products-vs-only-update-vs-only-create<\/a><\/p>\n\n\n\n

Happy Gaming All!<\/p>\n","protected":false},"excerpt":{"rendered":"

There are mainly two ways to add inventory to our system. The first is to find the product and edit the price first then quantity after. Doing this one item at a time can get quite tedious, which is why another better way of doing this would be using our Mass Create! (Note, this article …<\/p>\n

Update your quantity and prices for your cards and games easily with Mass Create!<\/span> Read More »<\/a><\/p>\n","protected":false},"author":20,"featured_media":19041,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[23,29,50],"tags":[45,47,48,923,924,925],"class_list":["post-19040","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-crystal-updates","category-onboarding","category-support","tag-csv","tag-inventory","tag-mass-create","tag-prices","tag-quantity","tag-spreadsheet"],"crystal_rest_feed":{"author":"danmccarty","id":19040,"featured_image":{"original":"https:\/\/www.crystalcommerce.com\/blog\/wp-content\/uploads\/sites\/2\/2020\/05\/image-1-1.png","medium":"https:\/\/www.crystalcommerce.com\/blog\/wp-content\/uploads\/sites\/2\/2020\/05\/image-1-1-300x183.png","large":"https:\/\/www.crystalcommerce.com\/blog\/wp-content\/uploads\/sites\/2\/2020\/05\/image-1-1-1024x626.png","thumb":"https:\/\/www.crystalcommerce.com\/blog\/wp-content\/uploads\/sites\/2\/2020\/05\/image-1-1-245x150.png"},"title":"Update your quantity and prices for your cards and games easily with Mass Create!","link":"https:\/\/www.crystalcommerce.com\/blog\/2020\/05\/13\/update-your-quantity-and-prices-for-your-cards-and-games-easily-with-mass-create\/","date":"2020-05-13T16:10:38","content":"\n\n\n\n\nThere are mainly two ways to add inventory to our system.\n\n\n\nThe first is to find the product and edit the price first then quantity after.\n\n\n\nDoing this one item at a time can get quite tedious, which is why another better way of doing this would be using our Mass Create!\n\n\n\n(Note, this article uses Admin 2.0 but the steps will work with Admin 1.0 which very small modifications)\n\n\n\nUpdating Prices (always update prices first)\n\n\n\nFirst, head over to your Inventory Tab\n\n\n\n\n\n\n\nNext, select the category that you would like to update (we will choose Theros Beyond Death)\n\n\n\n\n\n\n\nFind the button with the three … and click it, then select ‘Export search results to CSV’\n\n\n\n\n\n\n\nYou will be taken to your File Reports page. (if you need to visit here again, you just need to click on Notifications > “You have xxx file reports”\n\n\n\n\n\n\n\nDepending on the size of the csv, it may take a few seconds or a couple of minutes. Once ready, click to Download Report\n\n\n\nWhen you view the spreadsheet file, it’ll look a little like this:\n\n\n\n\n\n\n\nAs we are only updating Quantity and\/Or Prices, a lot of the columns here are not needed. Do not hesitate to remove them.\n\n\n\n*Please refer to the mass create tab for columns that can only be used for the mass create*\n\n\n\nFor our task, we are only updating the prices of cards.\n\n\n\nRemove all the columns apart from:Product NameCategorySell Price\n\n\n\n\n\n\n\nWe can then put our spreadsheet on one side of our screens, and have another browser that can show us the price of cards on the other side, and update accordingly.\n\n\n\nYou can use any method and any source you like to update your prices.\n\n\n\nOnce you have your updated spreadsheet, head over to Inventory > Mass Create\n\n\n\n\n\n\n\nFor the next step, as we already have our spreadsheet with a category, we can check the option that says “This import contains multiple categories”. If you do not have a category in your spreadsheet, uncheck this and choose the category from the dropdown for Step 1\n\n\n\n\n\n\n\nStep 2: Double check the information here as it will tell you what can and cannot be uploaded\n\n\n\n\n\n\n\nStep 3: Choose your file to import.Make sure you have checked Category and name (as those are the columns we have chosen to use in our spreadsheet.Then, choose Only Update Products. This will only update your products (Reading the card, explains the card…)\n\n\n\n\n\n\n\nAnd success! You’ve just uploaded your spreadsheet to update your prices!\n\n\n\n\n\n\n\nClick on the Notifications on the top right hand corner to view the status of the mass create:\n\n\n\n\n\n\n\nOur first line here shows us that 500 products were updated!\n\n\n\n\n\n\n\nHere we can see that our card was updated to $1.08!\n\n\n\nUpdating Quantity\n\n\n\nUpdating Quantity is a similar process to updating prices, but there is an additional column\/s and there are two options to choose:\n\n\n\nWhen we update the quantity of a card \/ game, we need to tell the system, which condition are we adding quantity to?\n\n\n\n\n\n\n\nUsing the card Dalakos, Crafter of Wonders as our example again, we see that it has 5 different conditions, Near Mint, Light Play, Monderate Play, Heavy Play and Damaged.Note that there is even a Language variant, English.\n\n\n\nSo for our spreadsheet, we need to make sure that we add 2 more columns to it:\n\n\n\nConditionLanguage\n\n\n\nSo if we had cards for Dalakos, Craft of Wonders in Near Mint, Light Play, Moderate Play and Heavy Play, we would modify our spreadsheet like so:\n\n\n\n\n\n\n\nNotice how each Dalakos card has a corresponding Condition and Language.If you are not updating a certain condition and\/or language, there is no need to include it.\n\n\n\nNext, we need to add a column for updating Quantity.\n\n\n\nThere are two columns you can use, Qty or Add Qty\n\n\n\n\n\n\n\nQty allows you to enter in a number, and the system will take that value and that will be the quantity for that card.\n\n\n\nIf you were to use Add Qty instead as the column, that would take the value on the spreadsheet, and ADD it to the value you have in your system.\n\n\n\nNow when we process this spreadsheet (refer to the Mass Import section above), it will add quantity to our system for this card!\n\n\n\n\n\n\n\nFor more information around mass update, check out our help articles here!http:\/\/help.crystalcommerce.com\/en\/articles\/1296813-inventory-mass-create-tab-overviewhttp:\/\/help.crystalcommerce.com\/en\/articles\/1389615-troubleshooting-common-mass-create-errorshttp:\/\/help.crystalcommerce.com\/en\/articles\/1390110-mass-create-create-update-products-vs-only-update-vs-only-create\n\n\n\nHappy Gaming All!\n","excerpt":"There are mainly two ways to add inventory to our system. The first is to find the product and edit the price first then quantity after. Doing this one item at a time can get quite tedious, which is why another better way of doing this would be using our Mass Create! (Note, this article …\n Update your quantity and prices for your cards and games easily with Mass Create! Read More »\n","categories":[{"name":"CrystalCommerce Updates","slug":"crystal-updates"},{"name":"Onboarding","slug":"onboarding"},{"name":"Support","slug":"support"}],"comments":0},"_links":{"self":[{"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/posts\/19040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/comments?post=19040"}],"version-history":[{"count":0,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/posts\/19040\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/media\/19041"}],"wp:attachment":[{"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/media?parent=19040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/categories?post=19040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.crystalcommerce.com\/blog\/wp-json\/wp\/v2\/tags?post=19040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}