![]() ![]() If the ID column does not exist in your spreadsheet or it exists but is blank, and we can not find an ingredient in your account with the value in the Name column we will create a new Ingredient, otherwise we will update the existing ingredient in your account with the same Name.If the ID column does not exist in your spreadsheet, you may not change the name of your ingredient because we will use the Name column to look up the ingredient in your account. If you are using a spreadsheet that you downloaded from your account and it contains the ID column, you may use the bulk update feature to change or update your ingredient Name.If you leave this value blank, when updating we will look up the Ingredient in your account based on the value in the Name column, or create a new Ingredient in your account if an ingredient with that Name does not exist.If you change this value, the update will either fail, or it may overwrite other data in your account. ![]() This way you can then download the Excel sheet (with that one ingredient in it) in the correct format, which will help you on the right track. If you are just getting started and want to create all your ingredients, we recommend creating one ingredient using the web interface to start. That way you can be sure that your spreadsheet is the correct format and you have a smaller chance of making an error. The format of the file must be very specific, we recommend downloading your ingredients into a Microsoft Excel document straight from Recipe Cost Calculator and using that spreadsheet as a starting point for making your bulk changes. This document will attempt to explain which columns you can update and what the permitted data values are for those columns. This feature works by uploading a Microsoft Excel (preferred) spreadsheet containing the changes you wish to make to your ingredients. There are many columns and pieces of data in Ingredients that can be updated using our bulk update feature. ![]() ![]() You can use our bulk create / bulk update feature for this! Create or Update Ingredients in Bulk (Using Spreadsheets)Ī lot of times you might want to create or update many ingredients simultaneously without having to create or edit each one individually. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |